• 【原创】安装过程中出现SQL server服务无法启动


    花费了一个周末,折腾了注册表、服务,重启了无数次。还是未能如愿装上SQL server 2005.心一横,备份了一下数据,重装系统。看重装系统后,能不能顺利装上SQL server 2005.令人悲伤的是,辛苦了很久,眼看着快要顺利装上了,又跳出了“SQL server服务无法启动”这样的弹出框。先留着这问题,有空再来解决。

    以下是安装过程中弹出的画面:

    以下便是错误日志:

     2014-06-22 23:30:47.70 Server      Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
     Oct 14 2005 00:33:37
     Copyright (c) 1988-2005 Microsoft Corporation
     Developer Edition on Windows NT 6.2 (Build 9200: )

    2014-06-22 23:30:47.70 Server      (c) 2005 Microsoft Corporation.
    2014-06-22 23:30:47.70 Server      All rights reserved.
    2014-06-22 23:30:47.70 Server      Server process ID is 7936.
    2014-06-22 23:30:47.70 Server      Logging SQL Server messages in file 'E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.

    2014-06-22 23:30:47.70 Server      This instance of SQL Server last reported using a process ID of 7140 at 2014/6/22 23:29:20 (local) 2014/6/22 15:29:20 (UTC). This is an informational message only; no user action is required.

    2014-06-22 23:30:47.70 Server      Registry startup parameters:
    2014-06-22 23:30:47.70 Server        -d E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
    2014-06-22 23:30:47.70 Server        -e E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
    2014-06-22 23:30:47.70 Server        -l E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf

    2014-06-22 23:30:47.70 Server      Command Line Startup Parameters:
    2014-06-22 23:30:47.70 Server        -m SqlSetup
    2014-06-22 23:30:47.70 Server        SqlSetup
    2014-06-22 23:30:47.70 Server        -Q
    2014-06-22 23:30:47.70 Server        -q Chinese_PRC_CI_AS
    2014-06-22 23:30:47.70 Server        -T 4022
    2014-06-22 23:30:47.70 Server        -T 3659
    2014-06-22 23:30:47.70 Server        -T 3610
    2014-06-22 23:30:47.70 Server        -T 4010

    2014-06-22 23:30:47.73 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2014-06-22 23:30:47.73 Server      Detected 2 CPUs. This is an informational message; no user action is required.
    2014-06-22 23:30:47.76 Server      Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
    2014-06-22 23:30:47.86 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.

    2014-06-22 23:30:47.87 Server      Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
    2014-06-22 23:30:48.90 Server      Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
    2014-06-22 23:30:48.90 Server      Database Mirroring Transport is disabled in the endpoint configuration.
    2014-06-22 23:30:48.90 spid5s      Warning ******************
    2014-06-22 23:30:48.90 spid5s      SQL Server started in single-user mode. This an informational message only. No user action is required.
    2014-06-22 23:30:48.90 spid5s      Error: 15507, Severity: 16, State: 1.
    2014-06-22 23:30:48.90 spid5s      A key required by this operation appears to be corrupted.

    先留着,有空再把解决的方法贴上。

    从娃抓起学抓娃
  • 相关阅读:
    centos7 svn服务器的搭建
    fastdfs远程服务器java连接失败的问题
    Java实现视频网站的视频上传、视频转码、视频关键帧抽图, 及视频播放功能
    数据库访问辅助类SqlHelper
    实现基本的Ajax和Json请求
    在Asp.Net MVC中使用Repeater控件
    Asp.Net MVC向视图View传值的三种方法
    C#实现加简单的Http请求
    Http协议学习小结
    iOS开发之layoutSubviews
  • 原文地址:https://www.cnblogs.com/javasharp/p/3803268.html
Copyright © 2020-2023  润新知