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.
| Author |
Topic |
|
wisertime
Starting Member
28 Posts |
 Posted - 2008-04-18 : 14:28:52
|
| We are having problems w/ our agent. When we try to start it in computer management, it will say the agent started then stopped because it has nothing to do. In surface area config, when we try to start it it times out. Does anyone have experience with this? We are desperate. Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-18 : 14:33:49
|
| Check out the Application Log in Event Viewer for any other related messages.Have you tried rebooting? Do you have the latest service pack and GDRs applied?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
wisertime
Starting Member
28 Posts |
Posted - 2008-04-18 : 14:41:03
|
We just re-installed SP2 and rebooted a couple of times. The messages in event viewer read the same as surface area. There is something I noticed in the ODBC Connection Pooling. There are no SQl agent drivers there and on another server I checked out they have drivers in that area. Not sure what that means.quote:
Originally posted by tkizer
Check out the Application Log in Event Viewer for any other related messages.Have you tried rebooting? Do you have the latest service pack and GDRs applied?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
|
|
|
|
wisertime
Starting Member
28 Posts |
Posted - 2008-04-18 : 14:50:08
|
That was it. We were missing the ODBC reg keys.Thanks for your help!quote:
Originally posted by wisertime
We just re-installed SP2 and rebooted a couple of times. The messages in event viewer read the same as surface area. There is something I noticed in the ODBC Connection Pooling. There are no SQl agent drivers there and on another server I checked out they have drivers in that area. Not sure what that means.quote:
Originally posted by tkizer
Check out the Application Log in Event Viewer for any other related messages.Have you tried rebooting? Do you have the latest service pack and GDRs applied?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
|
|
|
|
|
|
|
SQL Server Agent won't start