sql-server – 无法使SQL Server通过SSMS启动或连接到本地数据库引擎

前端之家收集整理的这篇文章主要介绍了sql-server – 无法使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,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,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,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(使用与我在错误的机器上所做的完全相同的过程)来解决这个问题.当我有能量时,我会回来看看我是否可以在我的另一台机器上解决这个问题.如果我有成功,我会更新这篇文章.

解决方法

一个同事遇到类似的问题 – 几乎是相同的错误日志.他的根本原因是他尝试使用系统帐户在域控制器上安装sql Server.如果您必须在域控制器上安装sql Server,则可以在网络帐户下运行sql Server服务.
https://support.microsoft.com/en-us/kb/2032911
原文链接:https://www.f2er.com/mssql/75590.html

猜你在找的MsSQL相关文章