<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
SQL Server Agent failed to start
20 posts, Page 1 of 2
1
2
»»
SQL Server Agent failed to start
Rate Topic
Display Mode
Topic Options
Author
Message
- Win.
- Win.
Posted Tuesday, August 17, 2010 2:34 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, March 29, 2012 5:22 AM
Points: 260,
Visits: 800
Experts,
Greetings for the day...!!
I have severe problem, please help me to fix this.
I have a box which is with SQL 2005 EE + SP3 updated on Win 2003 + SP2.
Suddenly SQL Server agent failed to start, Log has no such cause and information other than agent shutdown.....
---------------------------
WMI Provider Error
---------------------------
The service did not respond to the start or control request in a timely fashion. [0x8007041d]
---------------------------
OK
---------------------------
cmd:
The application failed to initialize properly (0xc0000005). Click on OK to terminate the application.
No where found the resolution for this..
Can anyone have any ideas...??
Fast help appreciated...
Thanks,
- Win.
Cheers,
- Win.
" Have a great day "
Post #970191
Ramji29
Ramji29
Posted Tuesday, August 17, 2010 2:48 AM
SSC Veteran
Group: General Forum Members
Last Login: Friday, August 31, 2012 7:19 AM
Points: 225,
Visits: 419
Hi..
Can you plz provide more info on this as.... what exactly happen when the agent wasn't starting?? was it crashed or machine was rebooted or services were rebooted.... plz post the sql error log and sql server entries from event viewer...
Post #970201
- Win.
- Win.
Posted Tuesday, August 17, 2010 2:55 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, March 29, 2012 5:22 AM
Points: 260,
Visits: 800
Hi,
It was failed when server was rebooted. And we updated the domain account and password and tried restarting the services, but still it failed.....
Please find the below error log.
2010-06-25 02:52:33 - ? [100] Microsoft SQLServerAgent version 9.00.4035.00 (x86 unicode retail build) : Process ID 5172
2010-06-25 02:52:33 - ? [101] SQL Server REDMOND\XXXX version 9.00.4035 (0 connection limit)
2010-06-25 02:52:33 - ? [102] SQL Server ODBC driver version 9.00.4035
2010-06-25 02:52:33 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is REDMOND\XXXX
2010-06-25 02:52:33 - ? [310] 8 processor(s) and 4096 MB RAM detected
2010-06-25 02:52:33 - ? [339] Local computer is REDMOND\XXXX running Windows NT 5.2 (3790) Service Pack 1
2010-06-25 02:52:33 - ? [432] There are 11 subsystems in the subsystems cache
2010-06-25 02:52:35 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2010-06-25 02:52:35 - ? [129] SQLAgent$REDMOND\XXXX starting under Windows NT service control
2010-06-25 02:52:35 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2010-07-05 11:49:16 - ? [130] SQLAgent$REDMOND\XXXX stopping because of Windows shutdown...
2010-07-05 11:49:23 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2010-07-05 11:49:23 - ! [382] Logon to server 'REDMOND\XXXX' failed (SaveAllSchedules)
2010-07-05 11:49:32 - ! [359] The local host server is not running
2010-07-05 11:49:32 - ? [098] SQLServerAgent terminated (normally)
Cheers,
- Win.
" Have a great day "
Post #970205
- Win.
- Win.
Posted Tuesday, August 17, 2010 4:00 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, March 29, 2012 5:22 AM
Points: 260,
Visits: 800
Any suggestions please..........
Cheers,
- Win.
" Have a great day "
Post #970229
Ramji29
Ramji29
Posted Tuesday, August 17, 2010 6:22 AM
SSC Veteran
Group: General Forum Members
Last Login: Friday, August 31, 2012 7:19 AM
Points: 225,
Visits: 419
- Win. (8/17/2010)
Hi,
It was failed when server was rebooted. And we updated the domain account and password and tried restarting the services, but still it failed.....
Please find the below error log.
2010-06-25 02:52:33 - ? [100] Microsoft SQLServerAgent version 9.00.4035.00 (x86 unicode retail build) : Process ID 5172
2010-06-25 02:52:33 - ? [101] SQL Server REDMOND\XXXX version 9.00.4035 (0 connection limit)
2010-06-25 02:52:33 - ? [102] SQL Server ODBC driver version 9.00.4035
2010-06-25 02:52:33 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is REDMOND\XXXX
2010-06-25 02:52:33 - ? [310] 8 processor(s) and 4096 MB RAM detected
2010-06-25 02:52:33 - ? [339] Local computer is REDMOND\XXXX running Windows NT 5.2 (3790) Service Pack 1
2010-06-25 02:52:33 - ? [432] There are 11 subsystems in the subsystems cache
2010-06-25 02:52:35 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2010-06-25 02:52:35 - ? [129] SQLAgent$REDMOND\XXXX starting under Windows NT service control
2010-06-25 02:52:35 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2010-07-05 11:49:16 - ? [130] SQLAgent$REDMOND\XXXX stopping because of Windows shutdown...
2010-07-05 11:49:23 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2010-07-05 11:49:23 - ! [382] Logon to server 'REDMOND\XXXX' failed (SaveAllSchedules)
2010-07-05 11:49:32 - ! [359] The local host server is not running
2010-07-05 11:49:32 - ? [098] SQLServerAgent terminated (normally)
Does mssql service also running under this account??? just for testing purpose change the srvice account to local or add the service account to local admin (although its not recommended) but this will confimr if this is due to any permissions issues.... secondly have u added this new domain login for having "log on as service" rights??
Tell me if this helps.
Rohit
Post #970321
- Win.
- Win.
Posted Tuesday, August 17, 2010 6:43 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, March 29, 2012 5:22 AM
Points: 260,
Visits: 800
Hi Rohit,
Tested all the things with accounts and permissions. Still no use...
Its throwing the same error.
- Win.
Cheers,
- Win.
" Have a great day "
Post #970359
- Win.
- Win.
Posted Tuesday, August 17, 2010 6:46 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, March 29, 2012 5:22 AM
Points: 260,
Visits: 800
SQL Server Services are running fine with the same account.
Cheers,
- Win.
" Have a great day "
Post #970364
Ramji29
Ramji29
Posted Tuesday, August 17, 2010 6:53 AM
SSC Veteran
Group: General Forum Members
Last Login: Friday, August 31, 2012 7:19 AM
Points: 225,
Visits: 419
- Win. (8/17/2010)
Hi,
It was failed when server was rebooted. And we updated the domain account and password and tried restarting the services, but still it failed.....
Please find the below error log.
2010-06-25 02:52:33 - ? [100] Microsoft SQLServerAgent version 9.00.4035.00 (x86 unicode retail build) : Process ID 5172
2010-06-25 02:52:33 - ? [101] SQL Server REDMOND\XXXX version 9.00.4035 (0 connection limit)
2010-06-25 02:52:33 - ? [102] SQL Server ODBC driver version 9.00.4035
2010-06-25 02:52:33 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is REDMOND\XXXX
2010-06-25 02:52:33 - ? [310] 8 processor(s) and 4096 MB RAM detected
2010-06-25 02:52:33 - ? [339] Local computer is REDMOND\XXXX running Windows NT 5.2 (3790) Service Pack 1
2010-06-25 02:52:33 - ? [432] There are 11 subsystems in the subsystems cache
2010-06-25 02:52:35 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2010-06-25 02:52:35 - ? [129] SQLAgent$REDMOND\XXXX starting under Windows NT service control
2010-06-25 02:52:35 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2010-07-05 11:49:16 - ? [130] SQLAgent$REDMOND\XXXX stopping because of Windows shutdown...
2010-07-05 11:49:23 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2010-07-05 11:49:23 - ! [382] Logon to server 'REDMOND\XXXX' failed (SaveAllSchedules)
2010-07-05 11:49:32 - ! [359] The local host server is not running
2010-07-05 11:49:32 - ? [098] SQLServerAgent terminated (normally)
See to be honest your log doesn't seems to be complete and of today's date (25th June & 5th July)... did you checked the logs after you did your tests just now???
Post #970373
John Mitchell-245523
John Mitchell-245523
Posted Tuesday, August 17, 2010 6:55 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 4,434,
Visits: 7,218
Win
Since you're getting Logon to server 'REDMOND\XXXX' failed, I would guess that your SQL Server Agent doesn't have permission to log on. Have a look under Logins, and check that the SQL Server Account is there, or that a group of which it is a member is there. If you set up SQL Server to record failed logins then the login failure will also appear in the SQL Errorlog, along with the name of the login for which logon failed.
John
Post #970375
Perry Whittle
Perry Whittle
Posted Tuesday, August 17, 2010 12:08 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 5:53 AM
Points: 5,204,
Visits: 11,158
- Win. (8/17/2010)
And we updated the domain account and password
what tool did you use to update the service account username and password?
Services snapin
SQL Server Config Manager
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #970648
« Prev Topic
|
Next Topic »
20 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
