How to find SQL Server running port?

sql-server sql-server-2008 connection-string
keram picture keram · Sep 6, 2012 · Viewed 308.2k times · Source

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? :/

Answer

AnandPhadke picture AnandPhadke · Sep 6, 2012

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/

Related questions

A network-related or instance-specific error occurred while establishing a connection to SQL Server

I deployed my asp.net web application on somee.com, whenever I login into this site (ipc.somee.com) it gives me a network related error like: A network-related or instance-specific error occurred while establishing a connection to SQL Server. …

Read More
How do I convert this connection string to use integrated security?

I'm very much learning about SQL as I'm going along. Visual Studio makes it very easy to get the basics done, but now I want to publish a site, and I need some advice with regards to SQL security. This …

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More