问题 无法让SQL Server通过SSMS启动或连接到我的本地数据库引擎


SQL Server一直运行良好但从星期五开始我无法连接到SSMS中的数据库引擎。这恰好是我在Windows更新期间关闭笔记本电脑的原因,因为它似乎悬挂(我不知道这两者是否相关)。

从那以后我有:

  • 在更新失败之前返回到还原点
  • 从我的计算机中删除了SQL Server 2008
  • 将SQL Server 2012安装到我的计算机上。这在加载期间失败
  • 从我的机器中删除了标记为SQL Server的所有内容
  • 重做失败的Windows更新
  • 已安装的SQL Server 2012在加载时再次失败
  • 创建了自签名证书(http://technet.microsoft.com/en-us/library/cc753127(v=WS.10).aspx
  • 试图从服务和SSCM启动SQL Server没有运气
  • 尝试了SQL Server的各种登录选项 - 在本地系统下服务将启动但我仍然无法连接到SSMS中的数据库引擎
  • 阅读无尽的帖子和文章

任何人都可以帮助我在我的机器上启动SQL Server,然后使用SSMS连接到数据库引擎吗?

安装的故障日志提供了以下信息:

2013-03-05 12:17:37.34 Server  Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)  Dec 28   2012 20:23:12  Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)  
2013-03-05 12:17:37.34 Server  (c) Microsoft Corporation.  
2013-03-05 12:17:37.34 Server  All rights reserved.  
2013-03-05 12:17:37.34 Server  Server process ID is 5116.  
2013-03-05 12:17:37.34 Server  System Manufacturer: 'SAMSUNG ELECTRONICS CO., LTD.', System Model: 'RV411/RV511/E3511/S3511/RV711'.  
2013-03-05 12:17:37.34 Server  Authentication mode is WINDOWS-ONLY.
2013-03-05 12:17:37.34 Server  Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'.  
2013-03-05 12:17:37.34 Server  The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.  
2013-03-05 12:17:37.35 Server  Registry startup parameters:   
 -d C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf    
 -e C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG    
 -l C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf  
2013-03-05 12:17:37.35 Server  Command Line Startup Parameters:    
 -s "MSSQLSERVER"
 -m "SqlSetup"
 -Q
 -q "Latin1_General_CI_AS"
 -T 4022
 -T 4010
 -T 3659
 -T 3610
 -T 8015
 -T 902
2013-03-05 12:17:37.69 Server  SQL Server detected 1 sockets with 2 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing.  This is an informational message; no user action is required.  
2013-03-05 12:17:37.69 Server  SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.  
2013-03-05 12:17:37.69 Server  Detected 6004 MB of RAM. This is an informational message; no user action is required.  
2013-03-05 12:17:37.69 Server  Using conventional memory in the memory manager.  
2013-03-05 12:17:38.02 Server  Perfmon counters for resource governor pools and groups failed to initialize and are disabled.  
2013-03-05 12:17:38.73 Server  Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.  
2013-03-05 12:17:38.75 Server  Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.  
2013-03-05 12:17:38.75 Server  Database Mirroring Transport is disabled in the endpoint configuration.  
2013-03-05 12:17:38.76 Server  Software Usage Metrics is disabled.  
2013-03-05 12:17:38.92 spid4s  Warning
 ******************  
2013-03-05 12:17:38.92 spid4s  SQL Server started in single-user mode. This an informational message only. No user action is required.
2013-03-05 12:17:39.07 spid4s  Starting up database 'master'.  
2013-03-05 12:17:39.66 Server  CLR version v4.0.30319 loaded.  
2013-03-05 12:17:40.35 spid4s  SQL Server Audit is starting the audits. This is an informational message. No user action is required.  
2013-03-05 12:17:40.38 spid4s  SQL Server Audit has started the audits. This is an informational message.  No user action is required.  
2013-03-05 12:17:41.33 spid4s  SQL Trace ID 1 was started by login "sa".  
2013-03-05 12:17:41.60 spid4s  Server name is 'E2E-LAPTOP'. This is an informational message only. No user action is required.  
2013-03-05 12:17:41.82 spid12s Password policy update was successful.  
2013-03-05 12:17:41.87 spid12s Error: 17190, Severity: 16, State: 1.  
2013-03-05 12:17:41.87 spid12s Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.  
2013-03-05 12:17:41.87 spid12s Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.  
2013-03-05 12:17:42.00 spid12s Error: 17182, Severity: 16, State: 1.  
2013-03-05 12:17:42.00 spid12s TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.  
2013-03-05 12:17:42.00 spid12s Error: 17182, Severity: 16, State: 1.  
2013-03-05 12:17:42.00 spid12s TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.  
2013-03-05 12:17:42.00 spid12s Error: 17826, Severity: 18, State: 3.  
2013-03-05 12:17:42.00 spid12s Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.  
2013-03-05 12:17:42.00 spid12s Error: 17120, Severity: 16, State: 1.
2013-03-05 12:17:42.00 spid12s SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

2013年3月7日:我现在已经通过在一台闪亮的新Windows 8笔记本电脑上安装SQL Server来解决这个问题(使用与我在错误机器上尝试的完全相同的过程)。当我有能量时,我会回来看看我能否在其他机器上解决这个问题。如果我有任何成功,我会更新这篇文章。


6363
2018-03-05 17:44


起源

你有没有得到这个工作?谢谢!希望你做到了。 - Rachael
您好Rachel,您是否能够修复机器上的错误? - Abhijeet
不,我尽管尝试了所有建议的东西,但我从来没有工作过。最后我放弃了,并在另一台机器上运行它。 :( - Rachel Edge


答案:


一位同事陷入了类似的问题 - 几乎相同的错误日志。原因是他尝试使用系统帐户在域控制器上安装SQL服务器。如果必须在域控制器上安装SQL Server,请让SQL Server服务在网络帐户下运行。 https://support.microsoft.com/en-us/kb/2032911


6
2017-12-15 15:00





备份您的注册表


1
2018-03-05 17:54



我会试一试,让你知道会发生什么。祝我好运! - Rachel Edge
@RachelEdge,祝你好运! - Mike Perrenoud
我试过这个,不幸的是它对安装没有任何影响 - 没有更好(但没有更糟)。我在名称中卸载了所有带有SQL Server的程序。然后看了一下注册表。 Microsoft SQL Server节点中没有留下太多内容,但我删除了它。我还删除了MSSQLSERVER节点。当我安装时,我得到完全相同的错误消息'等待数据库引擎恢复句柄失败'。卸载后我的机器上有什么内容?错误消息提到证书。我试过创建一个自签名证书,但没有任何区别。任何帮助赞赏 - Rachel Edge
@RachelEdge,删除并删除自签名证书,然后尝试重新安装。确保注册表是干净的,然后重新安装。 - Mike Perrenoud
@RachelEdge我遇到了同样的创伤问题,我想知道这些微软人是如何等待人们的。现在转移到mysql和生活休息片。我建议你也应该这样做。 - Omer


您的错误似乎与您安装的证书有关。

本文建议更改SQL服务器将登录的服务,您可以在安装时或通过表面配置管理工具执行此操作。

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/56f14665-3f00-41ff-b002-bb5e86b3f219/


1
2018-03-05 18:03



我已经为SQL Server尝试了各种登录。如果我以本地系统身份登录但仍无法通过SSMS连接到数据库引擎,我可以运行该服务。 - Rachel Edge
如果您运行它并且无法登录,请尝试本指南: blogs.ameriteach.com/chris-randall/2009/12/11/... ,基本上你正在做的是通过后门进入单用户模式,在本地添加你的帐户。 - RandomUs1r


我知道帮助原始海报可能为时已晚,但我们遇到了同样的问题,我们没有尝试解决问题。最后,我们向微软公开了一个技术事件,这是我们提供的解决方案:

  • 备份下面的注册表项。

HKLM \ SOFTWARE \微软\加密\ MachineGuid 理想情况下,此键应该具有没有花括号的机器的GUID,因此{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}变为xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

  • 然后删除大括号。
  • 尝试重新启动并启动SQL服务。如果服务未启动,则卸载并重新安装SQL。

上述解决方案在两个单独的机器上工作,表现出这个问题。


1
2018-06-30 14:58



钥匙已经没有括号,所以这对我不起作用。 - David Ching


简而言之,您只需看到这篇文章就需要应用Service Pack及其累积更新,在较新的操作系统上,SSL证书将被更改为使用较新的TLS1.2禁用SSL2,SSL3等。 SQL Server不支持它,你需要应用补丁来启用它的支持,它将再次工作。


1
2017-11-02 19:58



谢谢,但有问题的机器不再使用,我的其他任何设备上都没有类似的问题。 - Rachel Edge