Event ID/Source search
Keyword searchExample: Windows cannot unload your registry file
Event ID: 3 Source: SQLBrowser
The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid.
|English: This information is only available to subscribers. An example of English, please!|
I have solved this problem by modifying the following registry setting:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\AdminConnection\Tcp\TcpDynamicPorts
The default value was 0 but I set it to 1434. I have restarted the SQL service and the error from the SQL Browser stopped being recorded at every startup.
ME823938 provides details about the use of TCP ports in SQL.
On SQL Server 2005 Express Edition, this event is "by design".
This message appears because the TCP/IP Protocol for the instance is disabled. If desired, you can enable the TCP/IP Protocol for the instance and then configure the IP addresses you want the instance to listen on.
|Private comment: Subscribers only. See example of private comment|
|Search: Google - Bing - Microsoft - Yahoo - EventID.Net Queue (0) - More links...|
|Custom search for *****: Google - Bing - Microsoft - Yahoo|
Send comments or solutions
- Notify me when updated