Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  


Reporting Services - The Item '/Data Sources' Does Not Exist - Lost Administrator rights to SSRS
Somehow lost admin privileges to view/edit the datasources and roles for SSRS.
On the reporting server, reset the SSRS server by performing the following:
1. Open SQL Server Configuration Manager
2. Right click 'SQL Server Reporting Services - properties'
3. Log On tab: choose 'Configure...' / Connect.
4. Verify that the 'Web Service Identity' has a red X and is not configured (if it is, then this is not the solution that will help you)
5. Use the buttons on the left to create a new Report Server Virtual Directory and Report Manager Virtual Directory (append 2 to the dir name so it is unique)
6. Delete the old directories from IIS and application pools
7. Now create new virtual directories again with the same name
8. In 'Web Service Identity' section, create your report server/manager app pools with correct identity.
9. Verify that SSRS is back up.

Created By: amos 1/5/2011 5:13:05 PM
Updated: 1/5/2011 5:13:24 PM