My is SQL Server 2008R2, previously can normally start SQL Server (SQLEXPRESS), SQL Server (MSSQLSERVER), a few days did not open, just yesterday
After booting the MSSQLServer can not start, the information such as:
Quick fixes are as follows:
First Step: Open Event Viewer, view Windows logs, click Applications, view Windows error logs
Http://product.pconline.com.cn/itbk/software/win8/1211/3060037.html
Second step: You can see the related log information of startup failure after opening
Here are some information about the error copy:
The server TCP provider cannot listen on [' Any ' <ipv6> 1433]. The TCP port is already in use.
TDSSNIClient initialization failed with error 0x2740, status code 0xa. Cause: The TCP/IP listener could not be initialized. Typically, each socket address (Protocol/network address/port) is allowed to be used only once.
TDSSNIClient initialization failed with error 0x2740, status code 0x1. Cause: The initialization failed with an infrastructure error. Please check for previous errors. Typically, each socket address (Protocol/network address/port) is allowed to be used only once.
The network library could not be started because there was an internal error in the network library. To determine the cause, check the error log for those errors that precede this error.
SQL Server could not generate the FRUNCM thread. Review the SQL Server error log and the Windows event log for information about possible issues that may occur.
Step three: Click on the MSSQLSERVER protocol and select the TCP/IP protocol on the right side of the page
Fourth step: Right click on TCP/IP protocol, select "Properties", need to modify the port address of the connection database
Fifth step: Pop out the dialog box, there are many TCP/IP ports, find "IP3", change the IP address for their own computer's IP address (or 127.0.0.1)
On the TCP port, add 1433, and then select Start
Sixth step: "IPALL" all the ports are changed to "1433"
Seventh step: Will prompt TCP/IP only stop and restart, can take effect, click the OK button
Eighth step: Start the SQL Server (MSSQLSERVER) service
We successfully opened the SQL Server (MSSQLSERVER) service
Hope to help friends with similar problems
SQL Server 2008 MSSQLSERVER request failed or service is not responding in a timely manner