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.
| Author |
Topic |
|
charlie2869
Starting Member
3 Posts |
 Posted - 2011-11-09 : 11:53:01
|
| Auto backup were working both daily and weekly until this week. There have been others who have been working on this system for security changes. Windows 2008 R2 Server/32 bit systemHere is the application error in Event Viewer (taking any reference to actual names of servers out)SQL Server Scheduled Job 'xxx.backup.Daily. subplan_1'(0x01B48804598AA94495C74D6D333D3639) - Status: failed-Invoked on: 2011-11-09 11:26:00 - message. The job failed. Unable to determine if the owner (computer_name/Administrator)of job xxx backup - Daily. Subplan_1 has server access (reason: could not obtain information about Windows NT group/user 'computer_name/Administrator', error code ox534. [SQLSTATE 42000](Error 15404)Please help. Thanks ahead of time.Cheryl |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-09 : 11:57:00
|
| Change the job owner to sa. Or to an account with sufficient permissions. |
 |
|
|
charlie2869
Starting Member
3 Posts |
Posted - 2011-11-09 : 12:02:00
|
quote:
Originally posted by russell
Change the job owner to sa. Or to an account with sufficient permissions.
Hi Russel Thanks for the info but where exactly can I do this? I am not the person who normally handles this server. I did think it was a permissions issue and did give permissions to the share already. How do I change the job owner?Thanks again.cheryl callahan |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-09 : 12:05:28
|
| In Management Studio, expand the SQL Server Agent node, then jobs. Double-click the job. In the properties tab (opens by default) change the owner. |
|
|
|
charlie2869
Starting Member
3 Posts |
Posted - 2011-11-09 : 14:08:27
|
quote:
Originally posted by russell
In Management Studio, expand the SQL Server Agent node, then jobs. Double-click the job. In the properties tab (opens by default) change the owner.
Thanks so much for your help. I did this but it wouldn't change the ownership so I logged into the built-in admin account and realized that someone had change the admin built-in account name and that someone had created the jobs for backup as the old account login. The backup then worked after I changed the name back to the default. What I don't understand is why as I thought all objects had a GUID or UUID. I would think that even when renamed an object would still show that GUID number and the system would know what the object (the user name) was?cheryl callahan |
|
|
|
|
|
|
Scheduled Backup Not Working