Microsoft KB Archive/830215

= You receive a &quot;SuperSocket info: Failed to get Exclusive port use&quot; error message when you start an instance of SQL Server 2000 =

Article ID: 830215

Article Last Modified on 4/23/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



Bug #: 224968 (SQL Server 8.0)



SYMPTOMS
When you start an instance of Microsoft SQL Server 2000, you may receive the following error in the application log of the Windows Event Log:

Event Type: Error

Event Source: MSSQLServer

Event Category: (8)

Event ID: 19011

Date:

Time:

User: N/A

Computer:

Description: SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip [TCP/IP]) : Error 10013.

Note You do not notice any problems with TCP/IP communication between the server and its clients.



CAUSE
This problem occurs because the SQL Server service account is not a member of the local administrators group on the computer. Therefore, the SQL Server service account does not have the necessary access permissions to exclusively use the TCP/IP ports.



MORE INFORMATION
You can safely ignore the error message if the SQL Server service account is not a member of the local administrators group on the computer. This message is an informational warning message.

For more information about how to help secure your database server, visit the following MSDN Web site:

http://msdn2.microsoft.com/en-us/library/aa302434.aspx

