TCP/IP port on SQL server 2005

Question

TCP/IP port on SQL server 2005

SqlSavy

SSCarpal Tunnel

Points: 4065
More actions
July 19, 2012 at 8:27 am

#259666

SQL configuration , TCP/IP is configured with dynamic ports(ip1,ip2,ip3,ip4,ip5) but ‘IP all’ shows 5678 as port.
Errorlog shows two different port 5678 and 2932 (as below) which one to consider?
I would appreciate any help.
LogDateProcessInfoText
2012-07-06 21:01:19.790ServerA self-generated certificate was successfully loaded for encryption.
2012-07-06 21:01:19.810ServerServer is listening on [ 18.172.78.89 <ipv4> 5678].
2012-07-06 21:01:19.820ServerServer local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\INSTANCE05 ].
2012-07-06 21:01:19.820ServerServer named pipe provider is ready to accept connection on [ \\.\pipe\$$\servername\MSSQL$INSTANCE02\sql\query ].
2012-07-06 21:01:19.840ServerServer is listening on [ 18.172.78.89 <ipv4> 2932].

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

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

K Kumar SSCommitted Points: 1662 More actions · Answer 1

Simple test would be to try connecting to sql i..e if your server name is SQLSSCSRV, then try connecting from SSMS using "SQLSSCSRV,5678" & "SQLSSCSRV,2932".

- When sql is using dynamic port, its not guaranteed to get the same port next time its restarted.

...Kumar

SqlSavy SSCarpal Tunnel Points: 4065 More actions · Answer 2

tried connecting 'server/instance,5678' but failed with error.

Even tried 'IP,5678' but no luck yet

durai nagarajan SSCoach Points: 15778 More actions · Answer 3

is 2932 through ?

when did the sql service restarted last?

Regards
Durai Nagarajan

SqlSavy SSCarpal Tunnel Points: 4065 More actions · Answer 4

SQL server is on Cluster only two port entries are available in the errorlog. 2932 i think for dedicated administrator can't connect using this port.

Lowell SSC Guru Points: 323518 More actions · Answer 5

unless you obscured the items you pasted for security reasons, it looks like you have two instances installed:

SQLLocal\INSTANCE05,5678

SQLLocal\INSTANCE02,2932

so you should be able to conect to either of them by putting any of these addresses in, right:

SQLLocal\INSTANCE05
SQLLocal\INSTANCE02
SQLLocal\INSTANCE05,5678
SQLLocal\INSTANCE02,2932
18.172.78.89\INSTANCE05
18.172.78.89\INSTANCE02
18.172.78.89,5678
18.172.78.89,2932

does that sound right?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SqlSavy SSCarpal Tunnel Points: 4065 More actions · Answer 6

Thanks. Actually i've three named instances on a cluster but with different dynamic port numbers and each earrolog have two diffrent ports.

I tried all of them but none of them works in this case.

Thanks again