TCP/IP default port

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  January 13, 2003 at 9:30 am

  #159400

  Hi to all:

  from time to time I have to reboot my sql Server. But after this the default port of TCP/IP, 1433 doesn't open. So I have to reboot the win2000 server.

  Any idea of how can I restart my sql server 2000 instance and still have the port 1433 open?.

  thanks in advanced

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736078

  More actions

  January 13, 2003 at 10:16 am

  #446180

  Sounds like you have some bug set. Perhaps SQL is setup for dynamic ports? Check the network setup. I restart SQL and have no issues on a number of servers.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net