Unable to start SQL Agent - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

Unable to start SQL Agent

Author

Topic

cihayes
Starting Member

3 Posts

Posted - 2007-03-21 : 09:57:55

Hi,

I am having problems starting SQL Serve Agent. I keep gettings the following error:

If I then examine the Agent Error Log I find the following:
"[364] The Messenger service has not been started - NetSend notifications will not be sent"

I'm running SQL Developer on a standalone PC with XP Pro SP2. I've never encountered this error before, and this is not a new installation of SQL.

Thinking that the installation had become damaged/corrupted I uninstalled it and reinstalled back to SP4. Strange thing is, before updating to SP4 I checked the Agent and it was running without any issues.

Both the Server and Agent run under local admin accounts. The PC is not part of any domain.

The error appears to relate to the Messenger Service in XP. I currently have this disabled and it has been for some time and never caused an issue. Re-enabling it does not appear to cure the problem.

The error does not appear to coincide with anything I can find or determine.

Stumped!

Craig

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-03-22 : 14:52:55

Might be wise to bring this to the attention of member PaulRandal....he works in Microsoft and may be able to redirect to an appropriate support area.

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2007-03-22 : 15:45:22

Does the SQL Agent run when you are only at SP3(a)?

cihayes
Starting Member

3 Posts

Posted - 2007-03-22 : 16:19:29

Hi,

The unusual thing is, I've previously had this same installation (with SP4) with no issues whatsoever.

I haven't tried SP3a, but will give it a go - can't make it any worse ;).

Some input from Microsoft would be nice - haven't had much success searching the interweb for info.

Craig

cihayes
Starting Member

3 Posts

Posted - 2007-03-23 : 12:42:42

Update:

As per the advice above I uninstalled SQL and started afresh.

1. Installed SQL server, English Query and Analysis Services (AS) without issue.
2. Rebooted machine.
3. Opened Enterprise Manager and created two bog-standard maintenance plans for System and User databases (optimisation, integrity and backup).
4. Ran all jobs successfully.
5. Downloaded and installed SP3a for SQL and AS.
6. Rebooted machine.
7. Opened Enterprise Manager and successfully ran all jobs for a second time.
8. Downloaded and installed SP4 for SQL and AS.
9. Rebooted machine.
10. Opened Enterprise Manager and attempted to start SQL Agent. This was unsuccessful. Error as reported previously.

From this it would appear that the cause of this issue is a change that ossurs in SP4. However, as I have said before, I have had this same installation before with no problems.

The SQL Agent logs are as follows:

SQLAgent.1:
2007-03-23 15:08:07 - ? [100] Microsoft SQLServerAgent version 8.00.194 (x86 unicode retail build) : Process ID 5912
2007-03-23 15:08:07 - ? [101] SQL Server RIVENDELL version 8.00.194 (0 connection limit)
2007-03-23 15:08:07 - ? [102] SQL Server ODBC driver version 3.85.1117
2007-03-23 15:08:07 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local)
2007-03-23 15:08:07 - ? [310] 2 processor(s) and 1024 MB RAM detected
2007-03-23 15:08:07 - ? [339] Local computer is RIVENDELL running Windows NT 5.1 (2600) Service Pack 2
2007-03-23 15:08:07 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2007-03-23 15:08:07 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2007-03-23 15:08:07 - + [260] Unable to start mail session (reason: No mail profile defined)
2007-03-23 15:08:07 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2007-03-23 15:19:48 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
2007-03-23 15:19:50 - ? [098] SQLServerAgent terminated (normally)

SQLAgent.OUT:
2007-03-23 15:45:23 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID
2007-03-23 15:45:23 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 4948
2007-03-23 15:45:23 - ? [101] SQL Server RIVENDELL version 8.00.760 (0 connection limit)
2007-03-23 15:45:23 - ? [102] SQL Server ODBC driver version 3.85.1117
2007-03-23 15:45:23 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is
2007-03-23 15:45:23 - ? [310] 2 processor(s) and 1024 MB RAM detected
2007-03-23 15:45:23 - ? [339] Local computer is RIVENDELL running Windows NT 5.1 (2600) Service Pack 2
2007-03-23 15:45:23 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2007-03-23 15:45:23 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2007-03-23 15:45:23 - + [260] Unable to start mail session (reason: No mail profile defined)
2007-03-23 15:45:23 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2007-03-23 16:02:49 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
2007-03-23 16:02:52 - ? [098] SQLServerAgent terminated (normally)

SP4 was installed at approx 15:45

Any further ideas/suggestions would be appreciated.

I could start all over again and just upgrade to SP3a, but would prefer the enhancements in SP4 if possible.

Still stumped!

Craig

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources