You receive a "SuperSocket info: Failed to get Exclusive port use" error message when you start an instance of SQL Server 2000 (830215)

The information in this article applies to:

Microsoft SQL Server 2000 Standard Edition

Bug #: 224968 (SQL Server 8.0)
SQL Server 8.0:224968

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: Date
Time: Time
User: N/A
Computer: Computer_name
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://msdn.microsoft.com/library/en-us/dnnetsec/html/THCMCh18.asp

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

195445 PRB: RAW socket access denied to non-admin Windows NT 4.0 and Windows 2000 users

Modification Type:	Minor	Last Reviewed:	12/29/2005
Keywords:	kbEventLog kberrmsg kbprb KB830215 kbAudDeveloper