September 23, 2015 at 12:48 am
Hi folks
By looking at the configuration tool, I have seen my sql server agent service has stopped? But doing start its not responding. Please help.
Thanks
September 23, 2015 at 1:57 am
What does the Windows event log say?
September 23, 2015 at 2:18 am
It says "SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start)."
One thing more on which option I have to select the agent service type like local, system and network services.
Please recommend.
Thanks
September 23, 2015 at 2:28 am
What is in the SQLAgent.OUT file? You can find the location by right-clicking on SQL Server Agent and choosing Properties.
John
September 23, 2015 at 2:49 am
SQLAGENT.OUT file showing this message " ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] ".
September 23, 2015 at 3:12 am
OK, paste that into your favourite search engine - you should get quite a few suggestions.
John
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply