Build a great reporting interface using Splunk, one of the leaders in the Security Information and Event Management (SIEM) field, linking the collected Windows events to www.eventid.net. The EventId.Net for Splunk Add-on assumes that Splunk is collecting information from Windows servers and workstation via the Splunk Universal Forwarder.
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