SQL Server cannot generate fruncm threads. View SQL server error logs and Windows event logs ()
Preface:
This SQL service cannot be enabled today. Login Failure .. I searched Google Baidu. We found that many Websites collect data .. (It is strange that these collection sites are so forward !)
AccordingArticleI can't try the methods in it, but I finally found one .. Record. Original converted from: http://www.networkquestions.org /? P = 389. Thanks for the hard work of the original author.
The MSSQLServer service on the local computer is stopped after it is started. Some services are automatically stopped if they have nothing to do, such as the performance log and alarm service.
Open the Log Viewer and start viewing logs:
SQL Server cannot generate fruncm threads. Check the SQL Server Error Log and Windows event log to obtain information about possible problems.
The network library cannot be started because of an internal error in the network library. To determine the cause, check the errors that are located before the error in the error log.
Tdssniclient initialization failed, error 0x7e, statusCode0x1.
Check the SQL log (mssql.1mssqllog)
It can be determined that it may be due to the following issues:
1. Incorrect IP Address Configuration:
Open SQL Server Configuration Manager under Microsoft SQL Server 2005 Configuration tool, select MSSQLServer protocol, double-click the TCP/IP in the right window, and check the IP configuration in the pop-up window.
2. It may be because the via protocol is enabled. The solution is as follows:
In addition, changing the administrator password will also cause the SQL Server service to fail to start. The solution is as follows:
Open SQL Server Configuration Manager under Microsoft SQL Server 2005 Configuration tool and modify the account used to start the service in MSSQLServer service properties.
The reason why my machine cannot start the service is that the "via" service is enabled. After it is disabled, it is OK.
Preface:
This SQL service cannot be enabled today. Login Failure .. I searched Google Baidu. We found that many Websites collect data .. (It is strange that these collection sites are so forward !)
I can't try it according to the methods in the article. I finally found one .. Record. Original converted from: http://www.networkquestions.org /? P = 389. Thanks for the hard work of the original author.
The MSSQLServer service on the local computer is stopped after it is started. Some services are automatically stopped if they have nothing to do, such as the performance log and alarm service.
Open the Log Viewer and start viewing logs:
SQL Server cannot generate fruncm threads. Check the SQL Server Error Log and Windows event log to obtain information about possible problems.
The network library cannot be started because of an internal error in the network library. To determine the cause, check the errors that are located before the error in the error log.
Tdssniclient initialization failed, error 0x7e, status code 0 × 1.
Check the SQL log (mssql.1mssqllog)
It can be determined that it may be due to the following issues:
1. Incorrect IP Address Configuration:
Open SQL Server Configuration Manager under Microsoft SQL Server 2005 Configuration tool, select MSSQLServer protocol, double-click the TCP/IP in the right window, and check the IP configuration in the pop-up window.
2. It may be because the via protocol is enabled. The solution is as follows:
In addition, changing the administrator password will also cause the SQL Server service to fail to start. The solution is as follows:
Open SQL Server Configuration Manager under Microsoft SQL Server 2005 Configuration tool and modify the account used to start the service in MSSQLServer service properties.
The reason why my machine cannot start the service is that the "via" service is enabled. After it is disabled, it is OK.