Post reply

Error 1068 & Error 9003

  • March 1, 2008 at 1:10 am

    #120319

    hello there,

    Could someone help me with my server. I could not start SQLServerAgent.

    and have an error message:

    An error 1068 - (The dependency service or group failed to start.) occurred while performing this service operation on the SQLServerAgent Service.

    The startup account for both MSSQLServer and SQLServerAgent is on Local System Account.

    And on the SQL Error Log I got:

    2008-03-01 14:50:12.89 server Copyright (C) 1988-2002 Microsoft Corporation.

    2008-03-01 14:50:12.89 server All rights reserved.

    2008-03-01 14:50:12.89 server Server Process ID is 164.

    2008-03-01 14:50:12.89 server Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.

    2008-03-01 14:50:12.90 server SQL Server is starting at priority class 'normal'(1 CPU detected).

    2008-03-01 14:50:12.92 server SQL Server configured for thread mode processing.

    2008-03-01 14:50:12.92 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.

    2008-03-01 14:50:12.93 spid3 Starting up database 'master'.

    2008-03-01 14:50:12.96 spid3 Error: 9003, Severity: 20, State: 1.

    2008-03-01 14:50:12.96 spid3 Cannot recover the master database. Exiting.

    I thnik the SQLServerAgent won't start because the the ERROR 9003. May be my Db is corrupted.

    Is there anyone that could help me?

  • March 1, 2008 at 1:42 am

    #784130

    Did you install Service pack 2?

    Read this: http://support.microsoft.com/kb/940126

  • March 1, 2008 at 1:48 am

    #784131

    Hi

    I got this from microsoft site. This may help you.

    CAUSE

    Because the computer is a stand-alone computer, the NetLogon service does not start on the server, hence no domain-wide logon authentications are possible.

    RESOLUTION

    To resolve the problem, use these steps: 1. Change the startup account of both the MSSQLSERVER and SQLServerAgent to use the Local System account.

    2. Restart the computer.

  • March 1, 2008 at 1:53 am

    #784132

    No. I'm only using MSDE.

    Do I have to rebuild my master db?

    Is there another way to rebuild my master db, because I haven't seen rebuildm.exe in the bin folder.

    I think MSDE don't support rebuildm.exe feature.

  • March 1, 2008 at 2:05 am

    #784133

    They both on Local System account.

  • March 1, 2008 at 3:54 am

    #784140

    Hi,

    If you have access to CD's for SQL Server 2000 standard or ent, you may be able to build this way.

    Thanks,

    Phillip Cox

    MCITP - DBAdmin

  • March 2, 2008 at 6:21 pm

    #784277

    Thank you all,

    I've done it in MSSQL Server 2000.

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

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