Post reply

conecting to the server has probliem

  • October 8, 2008 at 4:36 am

    #124088

    "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)

    this is the error

    i am using sql server 2005

  • October 9, 2008 at 12:22 am

    #882706

    Hi,

    Is there a firewall between the client and the database server?

    Are you connecting to the correct machine and instance?

    PSA

  • October 9, 2008 at 1:35 am

    #882716

    Hi,

    SQL 2005 has option to block remote connection, make sure that "Allow Remote Connection" is enabled in SAC Tool

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

  • October 9, 2008 at 10:54 am

    #883032

    Also have a check on the Network configutaion on SQL Configuration manager 🙂

  • October 9, 2008 at 10:32 pm

    #883242

    i have connect correct meachione

    i am also cheaked networkconfigatration manager

  • October 9, 2008 at 10:45 pm

    #883245

    This problem occurs SQL 2005 onwards., Generally DBA's change the SQL Server permission, i.e. means allow the remote users.

  • October 10, 2008 at 7:31 am

    #883398

    Sometimes I get caught by this message when I try to connect to a server on which the SQL Server service has not been started, an easy thing to check, and for me, an easy thing to forget.

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

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