Post reply

SQL Server agent services is not running

  • September 29, 2015 at 12:23 am

    #308225

    Hi Folks

    How to resolve given below error from sqlagent.out file, please suggest. I have been trying to resolve this issue but not getting the output. My sql server agent service is running.

    2015-09-29 11:37:43 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002]

    2015-09-29 11:37:43 - ! [382] Logon to server 'RAMTECH-327\MSSQLSERVERNEW' failed (DisableAgentXPs)

    2015-09-29 11:37:43 - ? [098] SQLServerAgent terminated (normally)

    Thanks

  • September 29, 2015 at 12:42 am

    #1830046

    Under what service account does the Agent try to start?

    on your Server Server Agent connection Properties, do you have Alias local host server defined there ?

    if yes remove it leave it blank as that Alias does not exists.

    SQL 2000/2005/2008/2012 DBA - MCTS/MCITP

  • September 29, 2015 at 12:55 am

    #1830048

    sql server agent is running on network service account. No there is not aliases is configured.

  • September 29, 2015 at 12:58 am

    #1830049

    try this

    EXEC sp_configure 'show advanced options', 1

    RECONFIGURE

    GO

    EXEC sp_configure 'Agent XPs', 1

    RECONFIGURE

    GO

    SQL 2000/2005/2008/2012 DBA - MCTS/MCITP

  • September 29, 2015 at 1:08 am

    #1830051

    I already have tried this, still not working. :crying:

  • September 29, 2015 at 1:13 am

    #1830052

    you might have to run Repair of SQL Server instance, make sure you perform databases Backups before repairing

    SQL 2000/2005/2008/2012 DBA - MCTS/MCITP

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

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