Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to check Port 1433 is working for Sql Server or not?

Tags:

sql-server

How can I check whether port 1433 is open for Sql Server or not? I have set in bound and out bound rules, checked in SQL config manager but not sure whether it is working.

like image 991
LittleBirdy Avatar asked Aug 31 '16 07:08

LittleBirdy


People also ask

How do I check if port 1443 is open?

Simplest way to do that is probably (on the server, in a cmd window) netstat -an | find "1443" and see what you get back. Second, if it's a TCP connection you're looking for, you may be able to telnet <hostname> 1443 and see if you get a connection.

How do I test my port 1433 connection?

You can check TCP/IP connectivity to SQL Server by using telnet. For example, at the command prompt, type telnet 192.168. 0.0 1433 where 192.168. 0.0 is the address of the computer that is running SQL Server and 1433 is the port it is listening on.


2 Answers

You probaly want it open, since You are asking. The single most time-saving image I have found for this is here:

This is an inferred answer to the question, somewhat meta, but in my opinion the one that counts.

computer administration win 10

like image 66
user2692263 Avatar answered Sep 28 '22 00:09

user2692263


If TELNET is installed, you could use TELNET 1433 to verify port connectivity. Otherwise, the PowerShell command below can do the job using a .NET TcpClient:

$server="yourserver"; $port=1433; echo ((new-object Net.Sockets.TcpClient).Connect($server,$port)) "$server is listening on TCP port $port";

Newer versions of PowerShell include a Test-NetConnection cmdlet to facilitate testing ICMP and port connectivity. Example invocation from a Windows command prompt:

powershell -Command "Test-NetConnection -ComputerName 'yourserver' -Port 1433"
like image 45
Dan Guzman Avatar answered Sep 28 '22 00:09

Dan Guzman