How to determine sql connection port 1433

Question

Post reply

How to determine sql connection port 1433

Ed7

SSCrazy Eights

Points: 8516
More actions
May 15, 2007 at 10:55 am

#153588

I setup sql connection on port 1433 between location A and B.
Can anyone tell me how to determine the connection already establish?
So far I use netstat -an to validate.
On Server A, I type in netstat -an and it displayed server B public ip:
12.124.234.67:1433 ESTABLISHED.
On Server B, I type in netstat -an and it displyed server A public ip:
55.345.123.88: 1433 ESTABLISHED
Thank you.
Edwin

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

michaela SSCertifiable Points: 5649 More actions · Answer 1

SQL Server Configuration Manager -> SQL Server 2005 Services -> on sql server service, right click, then 2nd tab;

hope this is what you're looking for

Minaz Amin SSChampion Points: 11052 More actions · Answer 2

Hi,

Apart from you can also get the information in the SQL Server error log: You can check this line in the error log.

2007-04-15 17:35:28.92 Server Server is listening on [ 'any' <ipv4> 1433].

Hope this help..

Minaz

"More Green More Oxygen !! Plant a tree today"

Paul Rubel Ten Centuries Points: 1047 More actions · Answer 3

Another approach, hand for debuggin conectivity issues is

telnet ip

Ed7 SSCrazy Eights Points: 8516 More actions · Answer 4

Thank you all for responsea.

I created alias in SQL Server 2005 and 2000.

I did not see the IP address SQL Server 2005 show up in

Server B (SQL Server 200) when I typed "netstat -an".

Questions:

Shouldn't I see the sql server 2005 ip address in Server B.?

I cannot ping since the network guy disabled it. The only weapon for me

as junior DBA is to verify the connection utilize netstat-an.

There is no telnet server setup.

Can any one give me advise?

Thank you for your help.

TJ

Tim Cullen Ten Centuries Points: 1394 More actions · Answer 5

You don't have to have a "telnet server set up". You just use the command prompt: telnet 1433/1434. You can also type SQLCMD /L to see which instances are listening on the ports.

Ed7 SSCrazy Eights Points: 8516 More actions · Answer 6

Thanks a lot!!!

I tried telnet 1433/1434.

Connecting to 1433/1434..Could not open connection to the host, on port XX: Connection failed.