Post reply

Can''t start SQL Server Agent

  • May 23, 2005 at 4:14 pm

    #89260

    Hi!

    I am making some testes doing replication, between a Server with SQL Server 2000 and my computer that have SQL Server 2000 too.

    I got the next error from my computer:

    SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on server 'SQL_SMART' 

    5- (Acess is dennied)

    So I went to the server and checked the SQL Server Agent and it was Stop, I try to started it and the server send me the next message:

    SQL Server Agent

    Error:

    The server did not start due to a logon failure.

    An error 1069- (The service did not start due to a logon failure) occured while performing this service operation on the SQLServerAgent service.

    We restore the server to see if the SQL Server Agent start and it didn't.

    I really don't have an idea about how can do to solve this.

    I didn't install this server.

    Thanks for you help!

  • May 23, 2005 at 5:30 pm

    #560635

    The password for the SQL Server Agent startup service account is incorrect (probably changed).

    Solution

    To solve this problem, type the correct password in the Microsoft SQL Server agent service account on the SQL Server host computer.

    Regards,

    Patrick Molijn

    patrick@molijn.net

    Kindest Regards,

    Patrick Molijn

  • May 23, 2005 at 5:43 pm

    #560636

    I already do was said here:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q282254

    With out success.

    They changed the password of the windows Administrator user, so right now is not the same that when they Install SQL Server 2000.

  • May 23, 2005 at 5:56 pm

    #560637

    Can you connect to the SQL Server (assuming the server is running and only the agent is not) using the exact same username and password combination entered for the service account with SQL Query Analyser?

    Either:

    1. Right click the Query Analyser Icon and choose the Run as... option
    2. Login with the username and password on your workstation and launch Query Analyser then

    Are you using a local or domain account for the SQL Agent service account?

    Is it the same or does it differ from the SQL SERVER account?

    Kindest Regards,

    Patrick Molijn

  • May 23, 2005 at 6:16 pm

    #560638

    The SQL Server is running.

    I am using Windows Autentification has default.

     

    Where I can see what kind of  account I am using for the SQL Service Agent account?

  • May 23, 2005 at 6:28 pm

    #560640

    Click: Start->Run, type in: services.msc

    Scroll down to SQLSERVERAGENT. What do you see in the Logon as column (last column). see image below

    SQLAgent service

    In this scenario I'm running as user Patrick in the Molijn.NET domain.

    Changing the logon account can be done by double clicking the service and switching to the logon tab.

    Kindest Regards,

    Patrick Molijn

  • May 23, 2005 at 6:28 pm

    #560639

    I got it I do what said on the link that I mention but instead of doing that on the MSSQLSERVER I do it for the SQLSERVERAGENT, and finally it work.

    Thank a lot for your help, the way you asked me made me realiced that the MSSQLSERVER and SQLSERVERAGENT services were not the same. ( I had the idea that MSSQLSERVER include both)

  • May 23, 2005 at 6:35 pm

    #560642

    Glad the problem is sorted out now.

    Kindest Regards,

    Patrick Molijn

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply