Post reply

sql server 2005 is not starting

  • October 14, 2005 at 12:04 am

    #165655

    Hi all

     I have my web application with backend  as Sql Server 2005 CTP(Yukon).

    Initially It works well.

    I updated some security settings to the OS Windows Server 2003 and restarted the machine.

    Now the Sql Server is not starting.When I tried with Startup options by specifying it in commandline

    sqlservr.exe -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf  -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

    I got the following error log

    ----------------------------------------------------------------------   

    2005-10-13 06:30:57.93 spid5s      Starting up database 'master'.

    2005-10-13 06:30:58.01 spid5s      SQL Trace ID 1 was started by login "sa".

    2005-10-13 06:30:58.01 spid5s      Starting up database 'mssqlsystemresource'.

    2005-10-13 06:30:58.10 spid5s      Server name is "#####". This is an informational message only. No user action is required.

    2005-10-13 06:30:58.12 spid9s      Starting up database 'model'.

    2005-10-13 06:30:58.18 spid9s      Clearing tempdb database.

    2005-10-13 06:30:58.22 Server      The certificate was successfully loaded for encryption.

    2005-10-13 06:30:58.22 Server      Error: 17182, Severity: 16, State: 1.

    2005-10-13 06:30:58.22 Server      TDSSNIClient initialization failed with error 0x7e, status code 0x60.

    2005-10-13 06:30:58.22 Server      Error: 17182, Severity: 16, State: 1.

    2005-10-13 06:30:58.22 Server      TDSSNIClient initialization failed with error 0x7e, status code 0x1.

    2005-10-13 06:30:58.22 Server      Error: 17826, Severity: 18, State: 3.

    2005-10-13 06:30:58.22 Server      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.

    2005-10-13 06:30:58.22 Server      Error: 17120, Severity: 16, State: 1.

    2005-10-13 06:30:58.22 Server      SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

    ----------------------------------------------------------------------------------------------------------

    Any Solution for this.

    Thanks

    Thilak

  • October 14, 2005 at 1:04 am

    #597268

    What security settings did you update in the OS? Did you change any policies concerning the account SQL Server runs as? Which account is it running as?

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • October 14, 2005 at 1:28 am

    #597276

    Chris,

    Thank you for your reply.

    I installed the following security updates to my computer

    http://support.microsoft.com/?kbid=899589 MS05-046: Vulnerability in the Client Service for NetWare could allow remote code execution

    http://support.microsoft.com/?kbid=902400 MS05-051: Vulnerabilities in MS DTC and COM+ could allow remote code execution

    http://support.microsoft.com/?kbid=900725 MS05-049: Vulnerabilities in the Windows shell could allow for remote code execution

    http://support.microsoft.com/?kbid=896688 MS05-052: Cumulative security update for Internet Explorer

    http://support.microsoft.com/?kbid=901017 Vulnerability in the Microsoft Collaboration Data Objects could allow code execution (Windows)

    http://support.microsoft.com/?kbid=905414 MS05-045: Vulnerability in Network Connection Manager could allow denial of service

    http://support.microsoft.com/?kbid=904706 MS05-050: Vulnerability in DirectShow could allow remote code execution

     

    I tried running the sql server with

    NetworkService

    Local System

    Local Service and my account as Administrator

    Then I didnt make any other settings

    Any solution for my problem

    Regards

    Thilak

  • October 14, 2005 at 2:06 am

    #597284

    I found this KB support article that might have a solution. Although this discusses upgrading 2000 to 2005 the solution might still be applicable for your problem.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • October 14, 2005 at 5:45 am

    #597311

    Chris

    Thank you for your reply.

    I checked the certificate validity.It is a valid one.On error log Its mentioning certificate loaded successfullly

    after that message only its failing.with the error message I mentioned earlier.

    Any help.

    Regards

    Thilak

  • October 14, 2005 at 6:38 am

    #597326

    With it being a beta (even if an RC) I would probably reinstall and see if that helps.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply