job failed om the sql server

Hi,

i have a problem when i schedule an agent on the sql server and i log off the sql server ,

the agent failed with this msg' in the event viewr :

Login failed for user 'sa'. [CLIENT: <local machine>].

the account that run the SQL AGENT is NT AUTHORITY\NETWORKSERVICE.

i guess the problem is there but i can't find how to resolve it?

i'll be happy for any help.

10X.

anyone plz...?|||

Hi everyone,

If more info is need i'll be happy to give...

Thanks.

|||I think NT AUTHORITY\NetworkService account is appropriate for MSDTC service but for SQL AGENT you need a domain account if you schedule activities on a network , so change SQL Agent logon account.|||Which service account is the service account running with ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

These resources may help you sort out the service account requirements for SQL Agent.

Configuration -Service Accounts, SQL Server 2005 - Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Configuration -Service Accounts, SQL Server or SQL Server Agent service account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/en-us/library/ms143691.aspx

Configuration -Service Accounts,Selecting an Account for the SQL Server Agent Service
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
http://support.microsoft.com/kb/907557

|||

the service account running with NT AUTHORITY\NetworkService.

(sql server agent service).

|||

As previously indicated, that is NOT a good account for the SQL Agent service.

Refer to the sources I posted for guidelines in setting up a domain account for your SQL Agent Service.