Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to find SQL Server running port?

Yes I read this How to find the port for MS SQL Server 2008?

no luck.

telnet 1433

returns connection failed, so I must specify other port.

I tried to use

netstat -abn

but I don't see sqlservr.exe or something similar on this list.

Why it so difficult to find that port? :/

like image 760
keram Avatar asked Sep 06 '12 09:09

keram


People also ask

What port SQL Server is running on?

By default SQL Server listens on TCP port number 1433, but for named instances the TCP port is dynamically configured.

How do I check if a port 1433 is open?

On the local machine, click the Start button and enter “CMD” in the search programs and files field. If the port 1433 is closed, an error will be returned immediately. If the port 1433 is open, you will be able to connect to the MS-SQL server.


1 Answers

Try this:

USE master GO xp_readerrorlog 0, 1, N'Server is listening on'  GO 

http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/

like image 55
AnandPhadke Avatar answered Sep 20 '22 07:09

AnandPhadke