SQL Server (MSSQLSERVER) service failed to start

Source: Internet
Author: User
Tags mssqlserver

Beijing's winter is particularly dry, a colleague in the early morning and the server to wipe out the spark of love, the results did not expect to cause the server can not boot, this can be embarrassing, the code can be hosted on the server, a will also wait for the line, it must be repaired AH. They said that the motherboard is broken, on the other to find a computer, directly to the server's hard disk and memory for the past (System what is on the hard disk above), Xiao Rookie first see so repair computer, did not expect to boot unexpectedly directly can make, really magical ah! After testing the unexpected discovery database can not link, a look is MSSQLServer service did not start, but start the service when unexpectedly error, last night also use of good, really strange!

The following is an error message:

The request failed or the service did not respond in a timely manner. See the event log or other applicable error logs for more information.

  Next is a variety of Baidu Google Blog Park, Emperor not negative, finally let me find a solution.

SQL Server cannot start a common failure, referring to comments from Edukit in http://bbs.csdn.net/topics/350146777:

  一、是否修改了操作系统密码?  

  修改操作系统密码,导致SQL不能启动的解决办法:  

  1.我的电脑--控制面板--管理工具--服务--右键MSSQLSERVER--属性--登陆--登陆身份--选择"本地系统帐户"

  或者:

  2.我的电脑--控制面板--管理工具--服务--右键MSSQLSERVER--属性--登陆--登陆身份--选择"此帐户"--密码和确认密码框中输入你修改后的Administrator密码。  

  我们服务器的系统是 Windows Server 2008 R2 Enterprise,所以对应的是:我的电脑--控制面板--系统和安全--管理工具--服务--右键MSSQLSERVER--属性--登陆--登陆身份--选择上面两种任意一种方式。 

  两者的区别:  

  选择第一种方式,以后修改了Administrator密码,不用再调整(但要求登陆操作系统的是系统管理员)。

  选择第二种方式,以后修改了Administrator密码,还要再重复做上面的操作。

  

May be because these days to install TFS2013 configuration domain changes the operating system password caused, anyway, using the above method Xiao Rookie has solved the problem, the successful connection on the SQL Server, other methods without my verification, it is not listed here, lest fraught!

SQL Server (MSSQLSERVER) service failed to start

Related Article

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.