问题描述
我是使用的vs2010,里面附带了一个sql2008.以往都没有问题,在我联网调试的时候,产生了这个问题。(联网调试也通过了,不过我不知道,为什么突然就变成这个样子了)。显示的是:“请求失败或服务未及时响应。”日志的内容如下:请各位大神指点下,不胜感激,我的QQ:384927881。请注明是因为服务无法打开加我的,谢谢2012-06-1322:29:41.17ServerMicrosoftSQLServer2008(SP1)-10.0.2531.0(IntelX86)Mar29200910:27:29Copyright(c)1988-2008MicrosoftCorporationExpressEditiononWindowsNT5.1<X86>(Build2600:ServicePack3)2012-06-1322:29:41.17ServerError:17054,Severity:16,State:1.2012-06-1322:29:41.17ServerThecurrenteventwasnotreportedtotheWindowsEventslog.Operatingsystemerror=1502(事件日志文件已满。).YoumayneedtocleartheWindowsEventslogifitisfull.2012-06-1322:29:41.17Server(c)2005MicrosoftCorporation.2012-06-1322:29:41.17ServerAllrightsreserved.2012-06-1322:29:41.18ServerServerprocessIDis2776.2012-06-1322:29:41.18ServerAuthenticationmodeisWINDOWS-ONLY.2012-06-1322:29:41.18ServerLoggingSQLServermessagesinfile'C:ProgramFilesMicrosoftSQLServerMSSQL10.SQLEXPRESSMSSQLLogERRORLOG'.2012-06-1322:29:41.19ServerThisinstanceofSQLServerlastreportedusingaprocessIDof3900at2012-6-1322:24:04(local)2012-6-1314:24:04(UTC).Thisisaninformationalmessageonly;nouseractionisrequired.2012-06-1322:29:41.19ServerRegistrystartupparameters:-dC:ProgramFilesMicrosoftSQLServerMSSQL10.SQLEXPRESSMSSQLDATAmaster.mdf-eC:ProgramFilesMicrosoftSQLServerMSSQL10.SQLEXPRESSMSSQLLogERRORLOG-lC:ProgramFilesMicrosoftSQLServerMSSQL10.SQLEXPRESSMSSQLDATAmastlog.ldf2012-06-1322:29:41.21服务器SQLServerisstartingatnormalprioritybase(=7).Thisisaninformationalmessageonly.Nouseractionisrequired.2012-06-1322:29:41.21服务器Detected4CPUs.Thisisaninformationalmessage;nouseractionisrequired.2012-06-1322:29:41.54服务器Usingdynamiclockallocation.Initialallocationof2500Lockblocksand5000LockOwnerblockspernode.Thisisaninformationalmessageonly.Nouseractionisrequired.2012-06-1322:29:41.58服务器Nodeconfiguration:node0:CPUmask:0x0000000fActiveCPUmask:0x0000000f.ThismessageprovidesadescriptionoftheNUMAconfigurationforthiscomputer.Thisisaninformationalmessageonly.Nouseractionisrequired.2012-06-1322:29:41.60spid7sStartingupdatabase'master'.2012-06-1322:29:41.84spid7sFILESTREAM:effectivelevel=0,configuredlevel=0,filesystemaccesssharename='SQLEXPRESS'.2012-06-1322:29:41.90spid7sSQLTraceID1wasstartedbylogin"sa".2012-06-1322:29:41.91spid7sStartingupdatabase'mssqlsystemresource'.2012-06-1322:29:41.96spid7sTheresourcedatabasebuildversionis10.00.2531.Thisisaninformationalmessageonly.Nouseractionisrequired.2012-06-1322:29:42.12spid10sStartingupdatabase'model'.2012-06-1322:29:42.12spid7sServernameis'6BE9F15C871D409SQLEXPRESS'.Thisisaninformationalmessageonly.Nouseractionisrequired.2012-06-1322:29:42.12spid7s信息:找不到支持全文的语言。2012-06-1322:29:42.12spid7sStartingupdatabase'msdb'.2012-06-1322:29:42.16服务器错误:17190,严重性:16,状态:1。2012-06-1322:29:42.16服务器InitializingtheFallBackcertificatefailedwitherrorcode:1,state:1,errornumber:-2146893802.2012-06-1322:29:42.16服务器UnabletoinitializeSSLencryptionbecauseavalidcertificatecouldnotbefound,anditisnotpossibletocreateaself-signedcertificate.2012-06-1322:29:42.16服务器错误:17182,严重性:16,状态:1。2012-06-1322:29:42.16服务器TDSSNIClientinitializationfailedwitherror0x80092004,statuscode0x80.Reason:无法初始化SSL支持。找不到对象或属性。2012-06-1322:29:42.16服务器错误:17182,严重性:16,状态:1。2012-06-1322:29:42.16服务器TDSSNIClientinitializationfailedwitherror0x80092004,statuscode0x1.Reason:初始化失败,出现基础结构错误。请检查以前的错误。找不到对象或属性。2012-06-1322:29:42.16服务器错误:17826,严重性:18,状态:3。2012-06-1322:29:42.16服务器Couldnotstartthenetworklibrarybecauseofaninternalerrorinthenetworklibrary.Todeterminethecause,reviewtheerrorsimmediatelyprecedingthisoneintheerrorlog.2012-06-1322:29:42.16服务器错误:17120,严重性:16,状态:1。2012-06-1322:29:42.16服务器SQLServercouldnotspawnFRunCMthread.ChecktheSQLServererrorlogandtheWindowseventlogsforinformationaboutpossiblerelatedproblems.
解决方案
解决方案二:
搞定了,多谢hhnick大神。“自己找到解决方法了,在控制面板-服务中,将sql2008的服务的登录用户改为系统登录,重新启动服务,服务可以重新启动了,呵呵,这个问题好奇怪。”