SQL does not bind 1433 tcp port

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL does not bind 1433 tcp port

Author

Topic

Kleber
Yak Posting Veteran

67 Posts

Posted - 2005-08-16 : 10:29:05

Hi all,

I have a SQL Server 2000 that does not bind the 1433 tcp port.

The log says only: SQL server listening on Shared Memory, Named Pipes.

I used the site http://sqljunkies.com/How%20To/2E1101E0-D5C1-4DBD-A398-FE485DFA439B.scuk as reference to research for the problem, however. All settings listed there (Server Network Utility) are correct.

The ssnetlib.dll is installed.

So, what could I do to make my server listen this TCP port?

Kleber

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-08-16 : 12:12:37

is TCP/IP enabled in the Server Network utility? If it is what port is it listening? It is better practice not to use the default port.

====================================================
Regards,
Sean Roussy

Thank you, drive through

Kleber
Yak Posting Veteran

67 Posts

Posted - 2005-08-16 : 13:20:25

Sean,

TCP/IP is enabled properly and it is using 1433, but when I use "nbtstat -an" the server isn't listening the 1433 tcp port.

I found a MS article about it( http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q311/1/11.asp&NoWebContent=1), but I installed the SP4 twice, and it didn't work.

Any Idea?

Kleber

Kleber
Yak Posting Veteran

67 Posts

Posted - 2005-08-16 : 13:48:20

Hi,

I reinstalled MDAC 2.8 and SQL Server starts to listen 1433 port.

Problem solved.

Tks for your help.

Regards
Kleber

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources