ansaurus

Question

How to find the port for MS SQL Server 2008?

Answer 1

+1 A:

In the ERROLOG log for a line like below. If you don't see it the SQL Server isn't enabled for remote access, or it is just not via TCP. You can change this via the SQL Server Configuration Manager.

Server is listening on [ 192.128.3.2 <ipv4> 1433].

mrdenny 2009-10-05 08:30:28

I don't see that log but on the SQL Server Management Studio under Connections "Allow remote connections to this server" is checked. Hence, my understanding is that the remote connection is allowed.

royalGhost 2009-10-05 08:44:54

@royal: In addition to 'allow remote connections' you must also enable the TCP protocol. Right now the server is probably only listening NP

Remus Rusanu 2009-10-05 15:19:36

Answer 2

+2 A:

You could also look with a

netstat -abn

It gives the ports with the corresponding application that keeps them open.

Edit: or TCPView.

rslite 2009-10-05 08:51:36

Can you let me know under what name is MS SQL Server 2008 is named as an application?

royalGhost 2009-10-05 08:59:30

It should be sqlservr.exe (I don't have one to check though).

rslite 2009-10-05 09:12:02

ansaurus

tags:

views:

answers:

How to find the port for MS SQL Server 2008?

related questions