Sql-server – Unable to start the SQL Server Agent

sql-server-2008-r2sql-server-agentstandard-edition

I am unable to start then SQL Server Agent. I am getting the below error message when I tried to start the agent:

The SQL Server Agent service (DB_NN) on local machine was started and then stopped. Some services automatically stop if they are not used by any service or program

  • SQL version: SQL Server 2008R2 Standard Edition(RTM)
  • Windows:Windows server 2008 R2 enterprise

I verified below things, currently SQL agent is running through service account. I changed to local and tried to start. But agent didn't started.

How to fix this issue?

Best Answer

After reading your posting I understand that when you establish USBLAN_LDR service on windows server 2008, system prompt an error message.

According the information what you provided right now, it’s hard to determine what cause this issue, you may like to post more information about your environment (Event log ,Other System prompting etc… ).

Please check if it worked with assign a Local System account instead of Local Service account to run this service.

  • Open service MMC snap-in. ·

  • Right UBSLAN_LDR service , and click “properties”.

  • Click “Log on” tab , and assign a local account for running this services.

Seems this issue related to a third party software, I suggest to consult software vendor for future troubleshooting.

Please understand that I don't mean to bounce you between different solution provider as I am fully aware how time consuming this can be. However, they really are in a better position to be able to assist you with this issue as they may have experienced similar issues.

Related Question