Can't Start Report Manager - Permissions Errors - Help!

[masterbeat]

We are going insane trying to start Report Manager on a SQL Reporting Services 2000 installation. The programmer/admin who originally set this up for us is gone.

We recently upgraded our database/application server to a new server, causing the dataset in our reporting services installation to no longer be valid. Unfortunately, we do not have access to the original report project to 're-deploy' with the corrected dataset.

We desperately need to get the reports that are installed to retrieve their data from the new database location/machine. We understand this can be done by specifying a new data source in Report Manager.

For some reason, our Report Manager will no longer run - when we try to launch it, we get a windows login dialog - nothing will work here. We've tried both local and domain admins and constantly get ACCESS IS DENIED 401.3 error messages that we do not have permission/problems with ACL's.

We've gone so far as to allow EVERYONE read/write access to the ReportManager folder and virtual directories, but nothing seems to help.

Can anyone help with this? Ideas on how to change our data source, or how to get back into Report Manager?

Since we are somewhat technical, but not experts, and don't have much more time to waste, we are willing to pay $500 for this project to someone willing to access the server and fix the problem so that the reports point to the correct database.

Thanks in advance for your help.

 

[fuzzyocelot]

One thing I would check is the log files for the Report Server. Hopefully it will give you some more info to go on.

You can also try checking your IIS security settings. Is it set for Windows Authentication? Basic authentication?

Did you check the user accounts and permissions local to the server?

Are you using a domain or Active Directory?

Are you using Reporting Services 2005?

 

[fuzzyocelot]

Did you try logging in with an administrator account?