Post reply

Database Setup Information is invalid

  • June 29, 2009 at 11:13 am

    #206525

    When I try to connect to the SQL Server 2005 through SS Management Studio I am getting the below error

    Database setup information is invalid.

    An error has occurred while establishing 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)

    Rajesh Kasturi

  • June 29, 2009 at 11:31 am

    #1017011

    I am assuming you are attempting to connect from a separate system. What version of SQL Server was installed?

  • June 29, 2009 at 11:34 am

    #1017016

    well, just as the error message says, the first thing I'd do is check to see if the server allows remote connections:

    This issue vs your credentials in your signature don't seem to match up the way I would expect...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 29, 2009 at 11:47 am

    #1017023

    Hi,

    The error message is happening from the client computers, So I already verified the below things

    Step 1) Make sure SQL SERVER is up and the instance you try to connect is running.

    Step 2) Your system Firewall should not block SQL Server port.

    Step 3) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration

    Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.

    Step 4) Remote connections are enabled or not.

    As per the below blog I verified but there was no luck

    http://blogs.msdn.com/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx

    I am just suspecting that message "Database setup information is invalid", what does it mean.

    Rajesh Kasturi

  • June 29, 2009 at 11:48 am

    #1017025

    It allows remote connections

    Rajesh Kasturi

  • June 29, 2009 at 11:50 am

    #1017027

    another thing is that SQL Server clients were able to connect to sql server all of sudden it happened and they are facing the issues.

    Rajesh Kasturi

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply