Clever Geek Handbook

SQL Server 2008 - Report Manager URL shows page without Properties tab

I have developer edition of SQL Server 2008 and I am facing the following issues in front of 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 at the top left and links with the text "Home ',' My Subscriptions ',' Help 'in the upper right corner What is this, I don't see anything else I have a virtual directory with the same name as Report Manager in Reporting Services Configuration Manager.

  • Opening the report server in a browser gives the following error message -

    Reporting services error The report server cannot open a connection to the report server database. All queries and processing require a database connection. (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 available. Verify that the instance name is correct and configure SQL Server for remote connection. (provider: shared memory provider, error: 40 - could not open connection to SQL Server)

On the command line, I tried the following:

rsconfig -c -s <SQLSERVERNAME> -d reportserver -a Windows -u <MYDOMAIN\MYACCOUNT> -p <PASSWORD>

but I got another error: Report Server WMI Provider error: Invalid namespace

I would really appreciate any help on this.

amuses

+2


source to share


2 answers


I was finally able to work around these issues by opening a port in Windows Firewall for Report Server.

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



amuses

+2


source


1) Open Start -> SQL Server (20xx) -> find "Reporting Services Configuration Manager" in subfolders -> go to Database tab -> check if "SQL Server name" and "Database" Name "are selected correctly. This is the database where Reporting Services stores reports in it.



2) if everything is ok check if you have more sql instances. If you have multiple instances installed on your computer, select which one you want to use. for example sql server 2008 or sql server 2012. You may be using a Reporting Services 2008 URL that is not using the correct database in your "Reporting Services Configuration Manager"

+1


source






More articles:


All Articles