SQL Server agent service won't start

Posted on 2008-11-08
Last Modified: 2012-05-05
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
Question by:biotec
    LVL 4

    Expert Comment

    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.

    Author Comment

    SQL error 208 invalid object name msdb.syssessions
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    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.
    LVL 4

    Accepted Solution

    Take a peek here:
    Note the 2000 to 2005 upgrade.


    Author Closing Comment

    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.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now