SQL Server Performance

Error for Reporting Services

Discussion in 'SQL Server 2005 Reporting Services' started by madduri, May 25, 2007.

  1. madduri New Member

    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
  2. satya Moderator

  3. madduri New Member

    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
  4. satya Moderator

    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.

Share This Page