SQL Server Agent service won't start

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server Agent service won't start

Author

Topic

typo
Starting Member

14 Posts

Posted - 2012-09-11 : 13:39:03

Details:
-Using SQL Server 2005 on MS Win Server 2003 R2 SP2
-There are three separate instances on the server.
-All SQL Server services log on (startup) using a domain user account (Startup Type: Automatic)
-WSUS updates were applied. After a server reboot, all services restarted fine except for the SQL Server Agent of one instance. **Prior to WSUS updates and reboot, all services ran fine.

Error Message: "Could not start the SQL Server Agent(QA) service on Local Computer. Error 1067: The process terminated unexpectedly.

-Tried restarting the agent via the command prompt:
>sqlagent90 -i QA -c -v
Results:
2012-09-11 13:31:24 - ? [094] SQLServerAgent started from command line
2012-09-11 13:31:24 - ? [100] Microsoft SQLServerAgent version 9.00.3042.00 (x86
unicode retail build) : Process ID 6584
2012-09-11 13:31:24 - ? [101] SQL Server BNO-V-SD-SQL1\QA version 9.00.3080 (0 c
onnection limit)
2012-09-11 13:31:24 - ? [102] SQL Server ODBC driver version 9.00.3042
2012-09-11 13:31:24 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local
host server is BNO-V-SD-SQL1\QA
2012-09-11 13:31:24 - ? [310] 1 processor(s) and 4096 MB RAM detected
2012-09-11 13:31:24 - ? [339] Local computer is BNO-V-SD-SQL1 running Windows NT
5.2 (3790) Service Pack 2
2012-09-11 13:31:24 - ? [432] There are 11 subsystems in the subsystems cache
2012-09-11 13:31:24 - ! [125] Subsystem 'ActiveScripting' could not be loaded (r
eason: The specified module could not be found)
2012-09-11 13:31:25 - ! [364] The Messenger service has not been started - NetSe
nd notifications will not be sent

SQLAGENT.OUT
2012-09-11 13:31:24 - ? [094] SQLServerAgent started from command line
2012-09-11 13:31:24 - ? [100] Microsoft SQLServerAgent version 9.00.3042.00 (x86 unicode retail build) : Process ID 6584
2012-09-11 13:31:24 - ? [101] SQL Server BNO-V-SD-SQL1\QA version 9.00.3080 (0 connection limit)
2012-09-11 13:31:24 - ? [102] SQL Server ODBC driver version 9.00.3042
2012-09-11 13:31:24 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is BNO-V-SD-SQL1\QA
2012-09-11 13:31:24 - ? [310] 1 processor(s) and 4096 MB RAM detected
2012-09-11 13:31:24 - ? [339] Local computer is BNO-V-SD-SQL1 running Windows NT 5.2 (3790) Service Pack 2
2012-09-11 13:31:24 - ? [432] There are 11 subsystems in the subsystems cache
2012-09-11 13:31:24 - ! [125] Subsystem 'ActiveScripting' could not be loaded (reason: The specified module could not be found)
2012-09-11 13:31:25 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent

Your help is greatly appreciated....

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-09-11 : 13:48:15

What does the application log in Event Viewer show?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

typo
Starting Member

14 Posts

Posted - 2012-09-11 : 13:55:16

The only message posted in the Event Viewer is:
The SQL Server Agent (QA) service terminated unexpectedly. It has done this 13 time(s).

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-09-11 : 13:59:07

It seems the problem is with ActiveScripting, but I don't know what that is. Did you try another reboot just in case?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

typo
Starting Member

14 Posts

Posted - 2012-09-11 : 14:02:55

Yes I tried rebooting several times.

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-11 : 14:13:15

Run:

select * from syssubsystems

in MSDB and post th output.

-Chad

typo
Starting Member

14 Posts

Posted - 2012-09-11 : 14:23:26

1,TSQL,14556,[Internal],[Internal],[Internal],[Internal],[Internal],20
2,ActiveScripting,14555,D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\SQLATXSS90.DLL,NULL,ActiveScriptStart,ActiveScriptEvent,ActiveScriptStop,10
3,CmdExec,14550,D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\SQLCMDSS90.DLL,NULL,CmdExecStart,CmdEvent,CmdExecStop,10
4,Snapshot,14551,D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\SQLREPSS90.DLL,C:\Program Files\Microsoft SQL Server\90\COM\SNAPSHOT.EXE,ReplStart,ReplEvent,ReplStop,100
5,LogReader,14552,D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\SQLREPSS90.DLL,C:\Program Files\Microsoft SQL Server\90\COM\logread.exe,ReplStart,ReplEvent,ReplStop,25
6,Distribution,14553,D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\SQLREPSS90.DLL,C:\Program Files\Microsoft SQL Server\90\COM\DISTRIB.EXE,ReplStart,ReplEvent,ReplStop,100
7,Merge,14554,D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\SQLREPSS90.DLL,C:\Program Files\Microsoft SQL Server\90\COM\REPLMERG.EXE,ReplStart,ReplEvent,ReplStop,100
8,QueueReader,14581,D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\sqlrepss90.dll,C:\Program Files\Microsoft SQL Server\90\COM\qrdrsvc.exe,ReplStart,ReplEvent,ReplStop,100
9,ANALYSISQUERY,14513,D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\SQLOLAPSS90.DLL,NULL,OlapStart,OlapQueryEvent,OlapStop,100
10,ANALYSISCOMMAND,14514,D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\SQLOLAPSS90.DLL,NULL,OlapStart,OlapCommandEvent,OlapStop,100
11,SSIS,14538,D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\SQLDTSSS90.DLL,d:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe,DtsStart,DtsEvent,DtsStop,100

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-11 : 14:28:58

Does this exist?
D:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\binn\SQLATXSS90.DLL

-Chad

typo
Starting Member

14 Posts

Posted - 2012-09-11 : 14:31:42

Yes that file exists.

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-11 : 14:33:50

Does the SQL Agent Service account have access to that directory/file?

-Chad

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-11 : 14:35:28

Although, the message says it can't be found, so that doesn't seem like permissions. I am surprised it is there. It is the exact same path?

-Chad

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-11 : 14:39:34

If the permissions check out, I would try copying that file from the instance that is working (Make sure the versions are the same). Perhaps something happened to that file.

-Chad

typo
Starting Member

14 Posts

Posted - 2012-09-11 : 14:44:00

Yes the SQL Agent Service account has access to that file. It's a member of the Administers group, and the Administrators group has Full Control on that directory/file. Yes it is the exact same path.

Very strange...

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-11 : 15:38:29

Did you try copying a working copy of the file into that directory?

-Chad

typo
Starting Member

14 Posts

Posted - 2012-09-12 : 07:48:52

I just tried copying a working copy of the file into that directory. But I got the exact same error message.

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-12 : 12:42:10

Hmm, I am out of ideas then, I guess I would open a support case with Microsoft.

-Chad

typo
Starting Member

14 Posts

Posted - 2012-09-12 : 13:42:15

Thanks for your time. Does anyone else have any ideas?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-09-12 : 14:23:19

typo, Chad is from Microsoft. He's the best person on here for this, so I would definitely open a support case with Microsoft like he said.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

typo
Starting Member

14 Posts

Posted - 2012-09-12 : 14:41:43

Ok will do. How do I go about opening a support case with Microsoft? What's the url? I checked out the support page on their website, but don't see where to open a new case.

Thanks

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-12 : 16:13:41

http://support.microsoft.com/select/?target=assistance

-Chad

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-12 : 16:44:23

One thing I just noticed in the log is that SQL Server and SQL Agent are at differnt build numbers. I'm not sure if that is an issue or not, but seems odd. Can you check one of the instances that is working and see if that is the case with that instance?

-Chad

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources