sql server agent not starting - 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

General SQL Server Forums

New to SQL Server Administration

sql server agent not starting

Author

Topic

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2010-03-18 : 07:47:18

URGENT HELP needed

sql agent is stopped, i am unable to restart it. got below error

"The request failed or the service did not respond in a timely fashion.
Consult the event log or other applicable error logs for details."

Please advice

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2010-03-18 : 07:54:14

eventlog error:
Faulting application sqlagent90.exe, version 2005.90.1399.0, stamp 434f60a9, faulting module kernel32.dll, version 5.2.3790.4062, stamp 46264680, debug? 0, fault address 0x0000bee7.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-03-18 : 08:23:12

What does the sql server/sql agent error log say?

Management Studio -> Management -> SQL Server Logs -> Current
Management Studio -> SQL Server Agent -> Error logs -> Current

- Lumbago
If the facts don't fit the theory, change the facts. Albert Einstein

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2010-03-18 : 09:13:48

SQL Server Agent Error logs:

Date 3/18/2010 8:09:35 AM
Log SQL Agent (Current - 3/18/2010 8:09:00 AM)

Message
[364] The Messenger service has not been started - NetSend notifications will not be sent
===============
sql server logs:

Date 3/18/2010 8:09:35 AM
Log SQL Agent (Current - 3/18/2010 8:09:00 AM)

Message
[364] The Messenger service has not been started - NetSend notifications will not be sent
-----
Date 3/18/2010 8:09:35 AM
Log SQL Agent (Current - 3/18/2010 8:09:00 AM)

Message
[364] The Messenger service has not been started - NetSend notifications will not be sent
-------
Date 3/18/2010 8:09:35 AM
Log SQL Agent (Current - 3/18/2010 8:09:00 AM)

Message
[364] The Messenger service has not been started - NetSend notifications will not be sent
-----
Date 3/18/2010 8:09:35 AM
Log SQL Agent (Current - 3/18/2010 8:09:00 AM)

Message
[364] The Messenger service has not been started - NetSend notifications will not be sent
----
Date 3/18/2010 8:09:35 AM
Log SQL Agent (Current - 3/18/2010 8:09:00 AM)

Message
[364] The Messenger service has not been started - NetSend notifications will not be sent
---

Date 3/18/2010 8:09:35 AM
Log SQL Agent (Current - 3/18/2010 8:09:00 AM)

Message
[364] The Messenger service has not been started - NetSend notifications will not be sent

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2010-03-18 : 09:40:05

I have started SQL Agent with local system account succesfully, but unable to start with service account(pw is correct).

Temapararly issue is resolved, but I need to start service with service account, because all my logshipping jobs and shared folder access depends on this service account.

I will try to reboot the server today off hours...

does it make sense....any thoughts? THanks much!

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-03-18 : 10:02:19

Ok, if the agent runs fine with the local system account then you got an issue with the service account you're using. Are you sure that the account hasn't expired or the password has been reset or something? Is the account locked out? When changing account for the services, *always* change it through sql server configuration manager, never through the services mmc.

- Lumbago
If the facts don't fit the theory, change the facts. Albert Einstein

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2010-03-18 : 10:34:54

Password is correct and I had put never expired. It is working for other server.

I tried to connect sql server with that account in server , below error

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

I tried to connect sql thru my laptop, below error

Login failed for user 'abcd'. (Microsoft SQL Server, Error: 18456)

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-03-19 : 03:16:15

Hm, I have to admit that this isn't exactly my strong side but did you look at this thread? ->

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/0a58d127-f532-44f1-8507-f9131228b5c1/

- Lumbago
If the facts don't fit the theory, change the facts. Albert Einstein

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources