SuperSocket Info: Bind failed on TCP port 1433.

Print-vriendelijke versieStuur deze pagina doorPDF version

When starting Microsoft's SQL server on an SBS 2003 server, the following error occurs:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 2007/07/17
Time: 22:23:14
User: N/A
Computer: SERVER
Description:
19012 :
SuperSocket Info: Bind failed on TCP port 1433.

It seems that TCP port 1433 is used by another service or application.
Further investigation shows that the SQL$SBSMONITORING instance is the one that is listening to port 1433.

That instance shouldn't be listening to 1433 at all.
If you pull up the SQL Server Network Utility, the local SQL server instance should have the Named Pipes and TCP/IP in the enabled protocols.
The Monitoring, MSFW (ISA) and Sharepoint instance should have nothing listed in the enabled protocols by default.
Can you check this and remove it if they are enabled?

If enabled, you should disable them and restart all SQL Server instances. It might solve your problem!

If not, and eventid 19011 occurs, check this:

Description: "ConnectionListen(Shared-Memory (LPC)): Error 5" -

Review the REG_MULTI_SZ key under:
"HKLM\Software\Microsoft\Microsoft SQL server\{instancename}\MSSQLServer\SuperSocketNetLib\ProtocolList".
It should contain entries for "tcp" and "np" and maybe more if you have more subkeys under "SuperSocketNetLib".

Also check the two REG_SZ keys under "HKLM\Software\Microsoft\Microsoft SQL Server\{instancename}\MSSQLServer\SuperSocketNetLib\Tcp\TcpDynamicPorts" and
"HKLM\Software\Microsoft\Microsoft SQL Server\{instancename}\MSSQLServer\SuperSocketNetLib\Tcp\TcpPort".

In some cases, both values were empty. Changing both values to "2624" (as seen on another working server) and the MSSQL MSDE2000 engine started without the above error.

Nieuwe reactie inzenden

De inhoud van dit veld is privé en zal niet openbaar worden gemaakt.
CAPTCHA
Deze vraag wordt gebruikt om te bepalen of u een menselijke bezoeker bent en zo spam-inzendingen te vermijden.
Beeld-CAPTCHA
Enter the characters shown in the image.