Announcement

Collapse
No announcement yet.

SQL Server Agent not starting

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Server Agent not starting

    After doing some modifications, installations of new software, I rebooted my box (VM) and I am unable to start my SQL server. I go into services, select the server agent and try to start. I get the error 1068.

    The box is part of a domain, the DC is running but I still get the error. I have tried the logon for the Server agent with a domain account (with priviledges) as well as the local account.
    It also shows that the evaluation for my SQL Server has expired.

    Would this be the reason why the Server Agent cannot start?

    I was under the idea that once evaluation or trial period of software had ended, it restricted certain levels of access but not necessarily the whole application.

    Please advise.

    Thank you,

  • #2
    Re: SQL Server Agent not starting

    Is it the evaluation version -- if so, buy a full license and (IIRC) just enter the product key
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: SQL Server Agent not starting

      Originally posted by Ossian View Post
      Is it the evaluation version -- if so, buy a full license and (IIRC) just enter the product key
      I don't have access to purchasing the license currently. I would enter though if I did to rule that out. I just wanted to know if the expiration of the evaulation period would cause the SQL server agent not to start and generate the 1068 error.

      Comment


      • #4
        Re: SQL Server Agent not starting

        I know SSMS will not run and I believe the engine stops too -- assume nothing will work after evaluation is over
        Does this help: http://www.sqlcoffee.com/Troubleshooting073.htm

        Also http://sqlblog.com/blogs/jonathan_ke...tion-woes.aspx states services stop on expiration
        Tom Jones
        MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
        PhD, MSc, FIAP, MIITT
        IT Trainer / Consultant
        Ossian Ltd
        Scotland

        ** Remember to give credit where credit is due and leave reputation points where appropriate **

        Comment


        • #5
          Re: SQL Server Agent not starting

          Originally posted by Ossian View Post
          I know SSMS will not run and I believe the engine stops too -- assume nothing will work after evaluation is over
          Does this help: http://www.sqlcoffee.com/Troubleshooting073.htm

          Also http://sqlblog.com/blogs/jonathan_ke...tion-woes.aspx states services stop on expiration
          It helps greatly, thanks!

          Comment


          • #6
            Re: SQL Server Agent not starting

            Always assume evaluation versions (of anything) will stop completely and you will never be disappointed. At least you have an upgrade route without a reinstall!
            Tom Jones
            MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
            PhD, MSc, FIAP, MIITT
            IT Trainer / Consultant
            Ossian Ltd
            Scotland

            ** Remember to give credit where credit is due and leave reputation points where appropriate **

            Comment

            Working...
            X