SQL Server 2008 MSSQLSERVER request failed or service is not responding in a timely manner

Source: Internet
Author: User
Tags mssqlserver server error log

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.