Share via

Can't connect SQL Server via TCP/IP

  • Article
  • 02/16/2012

Question

Thursday, February 16, 2012 8:28 AM

I got a SQL Server that can't be connected via TCP/IP, but named pipe is ok. I'm sure that I enabled TCP/IP protocol, both on client and server. It's a default instance listening default port 1433. Anybody can help me?

All replies (8)

Thursday, February 16, 2012 10:03 AM ✅Answered | 1 vote

To see if your TCP/IP protocol works, you can connect trough SSMS with

tcp:<IPAddress>[\instancename>],<port>

for default instance:

tcp:IPADRESS\microsoftsql,1433

Thursday, February 16, 2012 9:59 AM | 1 vote

Hi,

go to Start > Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager check if Client Protocols and Protocols for MSSQL server have TCP/IP enabled. If not, simply right-click protocol name and enable it.

Regards

Thursday, February 16, 2012 11:56 AM | 1 vote

To see if your Server is accepting connection on port 1433 

Run  **telnet IPADDRESS 1433  **from the command prompt. If the screen goes blank then it's fine otherwise check firewall settings. Although firewall is irrelevant if you are connecting from local machine. 

Thanks, Harpreet http://myharpreet.blogspot.com

Thursday, February 16, 2012 12:37 PM

Hello

Check if the Windows Firewall is enabled on the server. You should disable it or add SQL TCP Ports to the execption list

Regards

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Friday, February 17, 2012 2:02 AM

I tried the tcp:IPADRESS,1433, that server can't be connected, but another server can.

Friday, February 17, 2012 2:05 AM

Even I telnet it from the local server, it can't be connected. But the TCP/IP protocol of this sql server is enabled .

Friday, February 17, 2012 5:54 AM

hi check if port 1433 is blocked from any applilcaiyion like, firewall,anit vuris etc...

Monday, February 20, 2012 1:04 PM

disable firewall on server and check if you can connect