SQL Server 2008 - The report manager URL shows a page without Properties tab

sql-server-2008 reporting-services reportserver reportmanager
Arnkrishn picture Arnkrishn · Oct 10, 2009 · Viewed 12.9k times · Source

I have SQL Server 2008 Developer Edition and I'm facing the following issues with the Reporting Services.

  1. 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.

  2. 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 namespace

I would really appreciate any help on this.

cheers

Answer

Arnkrishn picture Arnkrishn · Oct 12, 2009

I was finally able to get through both the problems by opening a port in Windows firewall for the Report Server.

For Windows 2003 and Vista the steps are mentioned here http://msdn.microsoft.com/en-us/library/bb934283.aspx

cheers

Related questions

SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More
Using the IN operator to filter in reporting services

Can anyone advise what the syntax should be when using the IN operator within a table filter. I have tried the below but the snytax is wrong:

Read More
How do I write an if else statement in Reporting Services expression language?

I would like to write a Reporting Services "Expression" that basically behaves as the following (pseudo code)... if ([Fields!StateProvinceId.Value] == 1) { return "Ontario"; } else if ([Fields!StateProvinceId.Value] == 2) { return "Quebec"; } else if ([Fields!StateProvinceId.Value] == 3) { return "Manitoba"; } // ... // more cases same …

Read More