After the deletion of a domain account SQL Server we receive a error owner is not available The job failed. Unable to determine if the owner
Posted by Cereal
Friday, May 07, 2010 1:00:00 AM
Rate this Content
0
0 Votes
After the deletion of a domain account that we have used to create databases and SQL Server 2005 / 2008 jobs, when we want to access to the properties of databases we receive a error message like “property owner is not available for Database […]”and all SQL Server jobs won’t start with error “The job failed. Unable to determine if the owner (…) job xyz has server access”.
Database properties error
Cannot show requested dialog.
Cannot show requested dialog. (SqlMgmt)
Property owner is not available for Database [xyz]. This property may not exist for object, or may not be retrievable due to insufficient access rights.
(Microsoft.SQLServer.SMO)
Solution
Change database owner from a TSQL query.
USE MyDatabase
EXEC sp_changedbowner 'TheNewOwner'
SQL Server job error
The job failed. Unable to determine if the owner (XYZ) of job xyz has server access (reason: Could not obtain information about Windows NT group/user XYZ', error code 0x534. [SQLSTATE 42000] (Error 15404)).
Solution
Option 1 : Change manually the owner of SQL Server job.
Option 2 : Change the owner from a TSQL query
EXEC MSDB.dbo.sp_update_job
@job_name = 'MyJobName',
@owner_login_name = 'TheNewOwner'
GO
Simple-Tech.info