Scheduled backup job failing - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Scheduled backup job failing

Author

Topic

rado
Starting Member

18 Posts

Posted - 2004-09-02 : 12:31:04

Hi everyone,

I'm a newbie into DB administration, and I've been playing with scheduled backups lately. I have created a scheduled backup using the All Tasks -> Backup database, and then modified the schedule in the SQL Agent -> Jobs. I can do the backup manually but when launched as a scheduled job, it will always fail with the following information in the event log on the server:

The job failed. Unable to determine if the owner (CECO\Rado) of job TestDB backup has server access (reason: Unable to connect to server - check SQL Server and SQL Server Agent errorlogs).

The SQL Agent error log contains this several times for each attempt:

[298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\SYSTEM'. [SQLSTATE 28000]

Thanks for any clues in advance.

Rado

X002548
Not Just a Number

15586 Posts

Posted - 2004-09-02 : 13:00:40

the account that the sql server agent is based on doesn't have authority

Brett

8-)

rado
Starting Member

18 Posts

Posted - 2004-09-02 : 13:15:12

Well, I supposed that it's something like this. :) But what is the best solution, change the account that the server agent is using, or add the System account to the database users (is the latter possible at all? When I tried to add System account to the server logins it didn't work). Or is there any other solution?

Thanks,
Rado

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-02 : 14:20:00

Change the job owner to sa. There is a fix but it involves adding accounts to the PreWindows 200 Compatible Group in Active Directory. So if you don't want to do that, then just change the owner to sa.

Tara

rado
Starting Member

18 Posts

Posted - 2004-09-02 : 14:59:21

I tried this but unforortunately changing the job owner didn't help. :'( It will throw the same error message.

Rado

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-02 : 15:05:25

So your MSSQLSERVER and SQLSERVERAGENT services should be using a domain account that has local admin privileges. Can you confirm this?

Tara

rado
Starting Member

18 Posts

Posted - 2004-09-02 : 16:28:28

It is a test and development server and both Server and Agent services are running under the local system account. Is this wrong?

Rado