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
biotecAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.