Post reply

Connection Problems from Client Error 26, remote connection etc

  • September 27, 2006 at 4:44 am

    #117009

     

    Hi all,

    I am having difficulties connecting to SQL 2005 standard edition from SQL 2005 express edition (Client connection).

    Server: SQL 2005 Standard edition on Windows 2000 Server

    Client: SQL 2005 Express on windows XP Firewall disabled

    Below is the error:

    Cannot connect to SPurina\SQLV1.

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

    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?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

    I have tried all the solutions put in the following websites: I have also configured the server to accept remote connections in the Surface area configuration.

     

    https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

    http://www.datamasker.com/SSE2005_NetworkCfg.htm

    I have changed the surface area configuration to accept both TCP/named pipes, as this was only configured for TCP/IP before, I have also checked the browser services, thats running, Windows XP firewall turned off.

    Looking forward to your reply.

    Thanks

    John

     

    Kindest Regards,

    John Burchel (Trainee Developer)

  • October 2, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • July 31, 2007 at 6:20 am

    #723539

    I have the same problem

    I was trying to connect from Server management studio and I get error 26 warning...

Viewing 3 posts - 1 through 2 (of 2 total)

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