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.SQLServerAgent service needs to run under a Windows account...|||Check your SQL Server connection settings in SQL Server Agent properties (Windows Auth. or SQL server Auth.).|||Thanks. I did not see the SQL agent connection properties with a login and password. All is now well.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment