Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arnkrishn
Starting Member
3 Posts |
 Posted - 2009-10-10 : 15:31:25
|
| HiI have SQL Server 2008 Developer Edition and I'm facing the following issues with the Reporting Services.When I open the Report Manager URL (I get it from the Reporting Services Configuration Manager) in a browser, it shows me a SQL Server Reporting Services page with a folder icon on top left and links with text 'Home', 'My subscriptions', 'Help' on top right. That's it, I don't get to see anything else. I have a virtual directory with the same name as specified for Report Manager in Reporting Services Configuration Manager.Opening the Report Server in the browser gives the following error message-Reporting Services Error: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)I tried the following at the command prompt in order to resolve it-rsconfig -c -s <SQLSERVERNAME> -d reportserver -a Windows -u <MYDOMAIN\MYACCOUNT> -p <PASSWORD>but I got another error saying Report Server WMI Provider error: Invalid namespaceI would really appreciate any help on this.cheers |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-11 : 14:44:36
|
| what role is assigned to account you used for connecting to report manager |
 |
|
|
arnkrishn
Starting Member
3 Posts |
|
|
|
|
|
The report manager URL doesn't show Properties tab