?
Solved

Can't Start SQL Server Agent service

Posted on 2009-12-17
7
Medium Priority
?
542 Views
Last Modified: 2012-05-08
I am unable to start the SQL Server Agent service on SQL Server 2008.  The error message I get when I try to start the service is "Object reference not set to an instance of an object"

Thanks for your help.
0
Comment
Question by:les28
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 13

Expert Comment

by:St3veMax
ID: 26073302
Look at SQLAGENT.OUT in the ERRORLOG directory where SQL is installed.

HTH
0
 
LVL 3

Expert Comment

by:Jlucht
ID: 26073314
What were you doing when this error occurred?  Where you trying to install something?
0
 
LVL 13

Expert Comment

by:sameer2010
ID: 26073458
Hi,

Can you stop the SQL server. Restart it. Login to SQLSERVERAGENT service with admin ID. Check if it restarts. If not, please post the log/messages.

Thanks,
Sam
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 1

Author Comment

by:les28
ID: 26075282
The database has been re-installed - the previous one choked on updating to sp1, so I uninstalled and reinstalled.

I did have a problem as per http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22697828.html

I also tried changing the security policy as per http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22665316.html -- adding the domain admins group.

I thought that this had been resolved -- refreshing after running the script doesn't show agentXP disabled anymore.  After attempting to start the server agent service however, the problem returns.

I have tried enabling the service through facets - server configuration with the same result.

SQL Agent out copied below.

Thanks everyone for responding:
2009-03-02 15:00:27 - ? [393] Waiting for SQL Server to recover databases...
2009-03-02 15:00:49 - ? [100] Microsoft SQLServerAgent version 10.0.1600.22 ((Unknown) unicode retail build) : Process ID 2872
2009-03-02 15:00:49 - ? [101] SQL Server MTI-2VM version 10.00.1600 (0 connection limit)
2009-03-02 15:00:49 - ? [102] SQL Server ODBC driver version 10.00.1600
2009-03-02 15:00:49 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
2009-03-02 15:00:49 - ? [310] 1 processor(s) and 3999 MB RAM detected
2009-03-02 15:00:49 - ? [339] Local computer is MTI-2VM running Windows NT 6.0 (6001) Service Pack 1
2009-03-02 15:00:50 - ? [432] There are 12 subsystems in the subsystems cache
2009-03-02 15:00:51 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2009-03-02 15:00:51 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2009-03-02 15:00:51 - + [260] Unable to start mail session (reason: No mail profile defined)
2009-03-02 15:00:51 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2009-03-02 15:06:59 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
2009-03-02 15:07:01 - ? [098] SQLServerAgent terminated (normally)
0
 
LVL 13

Accepted Solution

by:
sameer2010 earned 2000 total points
ID: 26075340
0
 
LVL 3

Expert Comment

by:Jlucht
ID: 26075344
Try installing the SQL 2000 tools and restart the service.  It sounds weird but Microsoft says it will fix it.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=367010
0
 
LVL 1

Author Closing Comment

by:les28
ID: 31667383
Changing the user that the service runs under worked.  Thanks.

Now that I have resolved this, I find I can't create maintenance plans.  (Which was one of the problems that prompted the first reinstall)

I have posted it as a separate question:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_24988268.html
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Screencast - Getting to Know the Pipeline

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question