Results 1 to 2 of 2

Thread: SQL server 2005 Enterprise edition remote connection issue

  1. #1
    Join Date
    Nov 2002
    Posts
    231

    SQL server 2005 Enterprise edition remote connection issue

    I have instealled SQL server 2005 Enterpise Edition. I can able to connecto local server but not able to connect in remote server and getting the below error. I have checked in Configuration manager and by default it was enabled the remote connection in Using TCP/IP only. I have tried to change remote connection into Using both TCP/IP and Named Pipe but still getting the below Error.
    I realy appreciate your suggestion.

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to sssss\SQL2K5.

    ------------------------------
    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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

    For help, click: http://go.microsoft.com/fwlink?ProdN...1&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

  2. #2
    Join Date
    Nov 2002
    Posts
    231
    I have resolved with help of Error Message 5: in the below link.
    http://blogs.msdn.com/sql_protocols/...22/506607.aspx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •