• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1279
  • Last Modified:

SQL Server agent service won't start

I am getting an error trying to start the sql agent service. It basically says that it can not create a new session. It gives an error in the event log of event id 103 which is vague and says that it started and stopped. We just upgraded from 2000 to 2005 and this problem began. Thanks
0
biotec
Asked:
biotec
  • 2
  • 2
1 Solution
 
joeviCommented:
More detail from the SQLAgent Log would help with your problem and should provide more than 'vague' info. But typically SQLAgent service issues are related to the service login account so you may want to locate the Service in Services and try and start the service with a different account.
0
 
biotecAuthor Commented:
SQL error 208 invalid object name msdb.syssessions
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is the sql server agent running under a domain account?
if yes, check out if that account has the following permissions on your windows server:
Lock Pages in memory.
0
 
joeviCommented:
Take a peek here:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=140929&SiteID=1
Note the 2000 to 2005 upgrade.

...Joe
0
 
biotecAuthor Commented:
Joevi this wasn't the exact answer but it lead me in the right direction. Thanks. I'm giving points to angelll on another question so it should even out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now