I am using the ARCserve SQL Agent to backup a SQL 2000 database on another server. However, whenever a job attempts to backup the database, I get this error:
E8604
Failed to start backup. (DBNAME=dbasql@MSSQLSERVER, EC=Windows Error 1326: Logon failure: unknown user name or bad password.)
I'm not sure why the job isn't able to logon. The authentication method on the SQL Server is SQL Server and Windows. I put in the 'sa' account username & password into the SQL Agent Account Config., and I use the same 'sa' account in the security settings when I create the backup job.
Any ideas?
E8604
Failed to start backup. (DBNAME=dbasql@MSSQLSERVER, EC=Windows Error 1326: Logon failure: unknown user name or bad password.)
I'm not sure why the job isn't able to logon. The authentication method on the SQL Server is SQL Server and Windows. I put in the 'sa' account username & password into the SQL Agent Account Config., and I use the same 'sa' account in the security settings when I create the backup job.
Any ideas?