error: 26 - Error Locating Server/Instance Specified

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)

Does anyone know what could be wrong ?

Check if the local/remote connections have been enabled for ur instamce....Launcg SQL Server Surface Area configuration...Connections and services...Check Local and Network connections.....|||Looks like you are trying to connect a remote named instance. To make it work, SQL Browser on the remote server must be enabled, UDP port 1434 should be put into exception if firewall presents.|||

I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode installation and default Instance name as the Machine Name. If, I connect through Windows Authentication mode then it shows the Error “General Network Error contact to Network Administrator Documentation” On client machine I am also connecting through Visual Studio 2005 Server Explorer but connection showing no database. What should I do to connect my client machine? If I create a New SQL Server Database Name in Server Explorer of Visual Studio 2005 it will give the Error Message “under the Default Setting SQL Server does not allow remote connection Network (provider: SQL Network Interface, Error: 26 – Error Locating Server / Instance Specified)

I already change the Remote Connection to Local & Remote Connection and choosing Option Use TCP/IP. But not succeeded

THANKS IF ANY BODY SOLVE MY PROBLEM

|||

Naeem Sheikh wrote:

I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode installation and default Instance name as the Machine Name. If, I connect through Windows Authentication mode then it shows the Error “General Network Error contact to Network Administrator Documentation” On client machine I am also connecting through Visual Studio 2005 Server Explorer but connection showing no database. What should I do to connect my client machine? If I create a New SQL Server Database Name in Server Explorer of Visual Studio 2005 it will give the Error Message “under the Default Setting SQL Server does not allow remote connection Network (provider: SQL Network Interface, Error: 26 – Error Locating Server / Instance Specified)

I already change the Remote Connection to Local & Remote Connection and choosing Option Use TCP/IP. But not succeeded

THANKS IF ANY BODY SOLVE MY PROBLEM

Thnanks i wonder firewall is blocking my tcp/ip port and now i am connecting to the server|||Yes. It that is necessary.