Tuesday, March 1, 2011

Errors During Configure Reporting Server(SQLServer2008R2)


Error:Network permission while opening of report manager
Solution:Open IE-->Tool-->Internet Options-->security--->Trusted Sites---->Click Sites Tab-->add http://servername and check "require server verification(https:) for all sites in the Zone" check box.


Error:The permissions granted to user 'domain\username' are insufficient for performing this operation."
Solution:change the security level to "0"(zero).
.....\Program Files\SQL Server 2008\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportServer.config


<Add Key="SecureConnectionLevel" Value="0"/>

By default the secure connection Level is "2",make it to "Zero"

Error:User 'bvp-PC\bvp' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed

solution:
  1. Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps:
  2. Start Windows Internet Explorer.
  3. On the Tools menu, click Internet Options.
  4. Click Security.
  5. Click Trusted Sites.
  6. Click Sites.
  7. Under Add this Web site to the zone, type http://<var>ServerName</var>. If you are not using HTTPS for the default site, click to clear the Require server certification (https:) for all sites in this zone check box.
  8. Click Add.
  9. Repeat step 7f and step 7g to add the http://localhost URL, and then click Close.
  10. Note This step enables you to start Internet Explorer and open either the localhost or the network computer name of the server for both the Report Server application and the Report Manager application.
  11. Create role assignments that explicitly grant you access together with full permissions. To do this, follow these steps:
  12. Start Internet Explorer together with the Run as administrator option. To do this, click Start, click All Programs, right-clickInternet Explorer, and then click Run as administrator.
  13. Open Report Manager. By default, the Report Manager URL is http://<var>ServerName</var>/reports.

    If you use SQL Server Express with Advanced Services SP2, the Report Manager URL is http://<var>ServerName</var>/reports$sqlexpress. If you use a named instance of Reporting Services, the Report Manager URL is http://<var>ServerName</var>/reports$<var>InstanceName</var>
  14. In the Home dialog box, click Properties.
  15. Click New Role Assignment.
  16. Type a Windows user account name by using the following format:
    <var>Domain</var>\<var>User</var>
  17. Click to select the Content Manager check box.
  18. Click OK.
  19. In the Home dialog box, click Site Settings.
  20. Click Configure site-wide security.
  21. Click New Role Assignment.
  22. Type a Windows user account by using the following format:
    <var>Domain</var>\<var>User</var>
  23. Click System Administrator.
  24. Click OK.
  25. Close Report Manager.
  26. Use Internet Explorer without the Run as administrator option to reopen Report Manager.


Errors: The request failed with HTTP status 502 :proxy error(No data record is avaliable)  while deploying reports in the reporting server:

solution:1.     Go to 'Tools -> Options'
2.     Go to 'Environment -> Web Browser'
3.     Click on 'Internet Explorer Options' button
4.     Navigate to 'Connections', click 'LAN Settings'
5.     Check if a proxy server set under "Use a proxy server for your LAN...." check box. If this value is not set:
1.     Check the above checkbox
2.     Specify a proxy server and port
3.     Check "Bypass proxy for local addresses"
4.     Click 'Ok', 'Ok' and 'Ok' to complete the settings.

1 comment:

  1. For 1st error
    Need to set value as 0(zero) for


    Path:
    D:\Program Files\SQL Server 2008\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportServer.config

    ReplyDelete