Post reply

Cannot Connect to the Server

  • November 14, 2008 at 1:58 pm

    #124853

    TITLE: Connect to Server

    ------------------------------

    Cannot connect to TINKUREDDY(my server name)

    ------------------------------

    ADDITIONAL INFORMATION:

    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)

    I did all that but i could no connect please respond

    Thank you

    I am learner please help.

  • November 14, 2008 at 2:09 pm

    #898877

    What authentication mode do you use?

    Can you connect to this server using IP address?

  • November 14, 2008 at 2:32 pm

    #898886

    This is my pc. I am using widows authentication.

  • November 14, 2008 at 2:32 pm

    #898887

    Please Help

  • November 14, 2008 at 2:35 pm

    #898888

    Is it a local server (same machine as you are on) or a different server?

    Some Sql Server Editions do not allow 'remote connections' by default.

    You want to open SAC [Surface Area Configuration] and allow remote connections over TCP/IP.

    Start >> All Prog >> Sql Server 2005 >> Cong. Tools >> SQL SA Configuration

    Open and go to 'Services and Connections' >> remote connections (or something like this)

    Hope this helps,

    _ub

    SqlTimes Blog on Sql Server

  • November 14, 2008 at 2:56 pm

    #898895

    judy and ub

    Thank you both

    it is working now actually it was some how stopped in surface area config

    so i went there and started.

    Thanks a lot for the help

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

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