Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Posts
    2

    Unanswered: Cannot run SQLServerAgent jobs after changing SA password

    I am new to SQL Server 2000. When I set a password for SA all the SQLServerAgent jobs fail with a login error and will not start. I have tried to change the SQLAgent service login via the Control Panel/Services, but it will not accept SA as a valid login, when I browse logins, only the NT logins seem to appear. The jobs are owned by my normal login and not by SA.

    This is probably a simple change, but I am going round in circles trying to locate the 'how to' documentation.

  2. #2
    Join Date
    Oct 2001
    Location
    Slovakia
    Posts
    3
    SQLServerAgent service needs to run under a Windows account...

  3. #3
    Join Date
    Oct 2001
    Location
    Slovakia
    Posts
    3
    Check your SQL Server connection settings in SQL Server Agent properties (Windows Auth. or SQL server Auth.).

  4. #4
    Join Date
    Jan 2002
    Posts
    2
    Thanks. I did not see the SQL agent connection properties with a login and password. All is now well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •