Event ID 208

[togi]

Event Type: Warning

Event Source: SQLSERVERAGENT

Event Category: Job Engine

Event ID: 208

Date: 9/29/2004

Time: 2:00:00 AM

User: N/A

Computer: UNITY1

Description:

SQL Server Scheduled Job 'SqlNightlyBackupJob' (0x3B279A1A86EDC848A6B3E8DAEDF0F4FB) - Status: Failed - Invoked on: 2004-09-29 02:00:00 - Message: The job failed. The owner () of job SqlNightlyBackupJob does not have server access.

First of all, it seems that DiRT is running fine, so I don't think this is a DiRT problem.

It's with the sqlsvragent. Is this just telling me that the account that's being used by the SqlNightlyBackupJob doesn't have permisisons to the SQL database?

This was brought on by a reboot of the server and as far as I know, nothing else has changed.

Thanks.

[rnarayana]

Can you please check under which account SQLserveragent and MS SQL server running.Usually this will be the local system account.

Thanks,

Radhika

[togi]

They are both running under a domain account called UnitySQL.

T

[togi]

The owner of this SQLSERVERAGENT job is a domain acct called unityinstaller, and even when created in the local administrators group, the job did not run.

I can change the owner of this job to the same acct that starts up SQLServer, do you think that would help?

Thanks.

P.S. Even though this fails, DiRT completes w/o error.

[rnarayana]

Try changing the SQL serveragent login to the one that SQL server is using.

Thanks,

Radhika

[lindborg]

Just as an aside, those jobs have nothing at all to do with DiRT - DiRT does it's own backups using SQL stored procs using the permissions of the account running DiRT. so the fact that DiRT runs but this fails is not realy related...