Post reply

sql agent cannto start

  • July 6, 2009 at 3:48 am

    #132482

    Hi,

    SQL server agent does not autostart when i reboot the server.

    Autostart check box is checked.

    i get follwoing error in sql logs...

    2009-07-02 14:14:54 - ! [298] SQLServer Error: 1265, Cannot generate SSPI context [SQLSTATE HY000]

    2009-07-02 14:14:54 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start

    2009-07-02 14:14:55 - ? [098] SQLServerAgent terminated (normally)

    SQL server 2000 running on windows 2003. Machine is PDC.

    Windows log shows follwoing error...

    Event Type:Error

    Event Source:KDC

    Event Category:None

    Event ID:11

    Date:04/07/2009

    Time:10:21

    User:N/A

    Computer:ANDH002

    Description:

    There are multiple accounts with name MSSQLSvc/Andh002.globalhospital-andheri.org:1433 of type DS_SERVICE_PRINCIPAL_NAME.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    i feel this error has conncection with the problem of server agent....

    can anyone hlep in this matter???

  • July 6, 2009 at 4:15 am

    #1020265

    Hi this is SPN related issue and has to be registered properly. Please refer the following link

    http://support.microsoft.com/?id=811889

  • July 6, 2009 at 6:30 am

    #1020313

    thanks for the reply.

    who will look after the SPN issue? DB admin or MCSE?

  • July 6, 2009 at 8:05 am

    #1020399

    Can be either one, but typically it's an admin that has rights to do this, not necessarily the DBA.

    MCSE isn't a job, it's a certification, by the way.

  • July 6, 2009 at 10:46 am

    #1020508

    yes i kno mcse is certification...

    so it is job of system engineer who has administrator rights

    thanks 🙂

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

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