Registry key changing in cluster environment

• aggletonm

  SSC Rookie

  Points: 36

  More actions

  May 20, 2003 at 4:51 am

  #80160

  We have a pair of servers running MS cluster (Win 2000/SQL 2000) which havve started exhibiting odd behaviour. If SQL fails over the registry key hklm\software\microsoft\mssqlserver\mssqlserver\supersocketnetlib\tcp\tcpport clears the value. SQL will not then come online. If we manually enter the port number (1433) we can bring it online.

  Has anyone any thoughts?

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  May 20, 2003 at 5:51 am

  #457791

  See Q308766 Verify your server registry:

  HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetlib\Tcp TcpPort:

  REG_SZ:1433

  Take a look at that technet article and see if it helps.

  Wes

• aggletonm

  SSC Rookie

  Points: 36

  More actions

  May 22, 2003 at 2:13 am

  #458102

  Thanks for that. As it happens we're running SP2 on the boxes.