Run SQL Server 2008 Reporting Services on Windows Vista

تکمیل نصب سیکوئل ریپورت سرویس

 پس از نصب سیکوئل سرور 2008 و ریپورت سرویس آن، صفحه مدیریت گزارش‌ها به صورت خالی نمایش داده می‌شود

I have done installation of SQL Server 2008 (also selected reporting serivces feature), now i open the report server configuration and from report manager tab i got link to open the report manager in browser.
Error is if i click on the link given (http://myservername:80/reports), it does not display in the browser, blank page displayed.

Solution:

1- Turn Off User Account Control (UAC) : Start -> Control Panel -> Security -> Parental Controls -> User Accounts -> Turn User Account Control On or Off -> Clear the checkbox: Use User Account Control (UAC) to help protect your computer -> Click OK -> You may need to restart your computer -> Test again

2- Configure local report server administration Configurations: (from Microsoft Site)

1. Open a browser window with Run as administrator permissions. From the Start menu, click All Programs, right-click Internet Explorer, and select Run as administrator.

2. Click Allow to continue.

3. In the URL address, enter the Report Manager URL.

4. Click Tools.

5. Click Internet Options.

6. Click Security.

7. Click Trusted Sites.

8. Click Sites.

9. Add http://.

10. Clear the check box Require server certification (https:) for all sites in this zone if you are not using HTTPS for the default site.

11. Click Add.

12. Click OK.

13. In Report Manager, on the Home page, click Properties.

14. Click New Role Assignment.

15. Type your Windows user account in this format: \.

16. Select Content Manager.

17. Click OK.

18. Click Site Settings in the upper corner of the Home page.

19. Click Configure Site-wide security.

20. Click New Role Assignment.

21. Type your Windows user account in this format: \.

22. Select System Administrator.

23. Click OK.

24. Close Report Manager.

25. Re-open Report Manager in Internet Explorer, without using Run as administrator.

    3- Turn On User Account Control (UAC) again : Start -> Control Panel -> Security -> Parental Controls -> User Accounts -> Turn User Account Control On or Off -> Select the checkbox: Use User Account Control (UAC) to help protect your computer -> Click OK -> You may need to restart your computer -> Test again

Environment configuration:

• Operating System (OS): Microsoft Windows Vista Ultimate SP1 will be upgraded to SP2
• .NET 3.
• SQL Server: Enterprise Edition with SP1
• Microsoft Visual Studio 2008 Professional SP1