CODEWITHSUNDEEP
sql-servertelnet
Eun
Eun

Reputation: 21

telnet localhost 1433 failed

I issued this command on the command line: 

telnet localhost 1433.

And I got this message:

Can not connect host, port 1433..

I tried telnet 127.0.0.1 1433 too.

I checked:

  1. In SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER > TCP/IP > STATUS IS SET TO "USE"

enter image description here

  1. Checked for firewall, and the firewall is off

  2. Tried to see if the port for 1433 is opend : netstat -an | find"1433" in the command line.

And the result is as below and I don't know what it means... Seems the port for 1433 is opened.

enter image description here

I need your help, please tell me why I can't connect SQL Server...

Upvotes: 2

Views: 9670

Answers (2)

alanextar
alanextar

Reputation: 1314

I had the same issue. There were 2 sql servers hosting on my pc: MSSQLSERVER and SQLEXPRESS. Just set different ports for them.

Upvotes: 0

Alireza Abdollahnejad
Alireza Abdollahnejad

Reputation: 1047

You need to open firewall for port 1433.

Go to Windows Firewall and add new inbound rule for port 1433.

Upvotes: 0

Related Questions