Error for Reporting Services | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error for Reporting Services

Hi, I am trying to create a report on my newly installed sql server 2005 Reporting services.
I am followig the tutorial to create a report on AdventureWorks. I am getting the following error. A connection cannot be made to the database.
Set and test the connection string. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) Can anyone help me to fix the problem. Thanks in advance. Regards, Madduri
Ensure the SQL & RS services are started already. http://msdn2.microsoft.com/en-us/library/ms156468.aspx
http://msdn2.microsoft.com/en-us/library/ms190204.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Thank you Satya! I tried to configure the database server but it is thrwing the following error. The database version (C.0.8.43) does not match your reporting services installation. This version of the database cannot be upgrated. you must use a different database. Any ideas please. Regards, Madduri
Resolve by following:
-Connect to the report server using the Reporting Services Configuration
-Select Database Setup from the navigation pane
-Click the Upgrade button
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=520422&SiteID=1 fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>