Narendra Tiwari

# re: SQL Server does not allow remote connections::Resolution

No resolution here. Sorry bro. 4/14/2007 1:03 AM | Jay Flowers

# re: SQL Server does not allow remote connections::Resolution

Enable TCP/IP 4/24/2007 9:24 AM | SY

# re: SQL Server does not allow remote connections::Resolution

Folks,

To go about this problem, do the following:
1. make sure that server and client use the same network protocol (enable TCP/IP).
2. Enable the service SQL Browser from your server.
3. Enable 'Allow remote connections' setting in the server.
4. check your server/workstation firewall.

Let me know if you have any luck with this.

Cheers,

Jimar 5/8/2007 7:46 AM | Jimar

# re: SQL Server does not allow remote connections::Resolution

Jimar,
I think step 3: Enable 'Allow remote connections' setting in the server. is the whole point of this request. How about posting the instructions for that step. 5/15/2007 7:37 AM | ds

# re: SQL Server does not allow remote connections::Resolution

Try here:

http://support.microsoft.com/kb/914277

6/28/2007 7:26 AM | MJ

# re: SQL Server does not allow remote connections::Resolution

I dont understand why I am getting this error repeatedly. I have two servers, both with sql server developer. Both have firewall turnon, both have a remote connection tunred on with tcp/ip selected. I can not access either servers and I get this error message below:
"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) (.Net SqlClient Data Provider)"
Please assist ASAP 10/17/2007 5:07 PM | James Mendez

# re: SQL Server does not allow remote connections::Resolution

Found out this whilst searching for an answer around

To enable remote connections:

Well, it turns out that this is controlled by an EXTERNAL utility, the Sql Server Surface Area Configuration Tool which can be found in Start Menu Sql Server Configuration section. By default Sql 2005 indeed refuses remote connections and you need to run this utility to enable remote connections. Intuitive isn't it? 11/2/2007 6:38 PM | Alex

# re: SQL Server does not allow remote connections::Resolution

Thanks! This helped me. 4/30/2008 12:09 AM | CJMAC

# re: SQL Server does not allow remote connections::Resolution

Hi ,
i have problem with this error. But my case is quite weird.
I have one application server, one db server,
in db server have 2 database.
i have 2 website in IIS in application, connect to db server.
Website one always can connect to db and working fine.
But Website two,which connect to another db, on and off will throw SQL server does not allow remote connection.
Any idea?
Please help.

However, we 12/17/2008 6:18 AM | boonting

# re: SQL Server does not allow remote connections::Resolution

Funciono, Solo habilite el puerto 1433 en el firewall de la máquina y listo, solo me faltaba ese paso.


Gracias 1/26/2009 9:17 PM | carlos caicedo

# re: SQL Server does not allow remote connections::Resolution

This worked for me but I had to reboot SQL2005Express machine after making the change.
It would not work otherwise
Well, it turns out that this is controlled by an EXTERNAL utility, the Sql Server Surface Area Configuration Tool which can be found in Start Menu Sql Server Configuration section. By default Sql 2005 indeed refuses remote connections and you need to run this utility to enable remote connections. Intuitive isn't it? 8/29/2009 1:56 AM | MPG

# re: SQL Server does not allow remote connections::Resolution

I hope you will provide better solutions 9/20/2011 10:49 PM | bhurani