Error when trying to schedule job in SQL 2008
in [Server Configuration]
|
Prev: How to correctly uninstall SQL Analysis service form SQL Server 2008 cluster?
Next: Error making target server on multiserver envmnt
From: MH39 on 20 May 2010 11:11 I am trying to schedule a job in SQL 2008 using a proxy however get an error: The job failed. Unable to determine if the owner (NICE-PAK\SVC_Sostenuto) of job Sostenuto AD Import has server access (reason: Could not obtain information about Windows NT group/user 'NICE-PAK\SVC_Sostenuto', error code 0x5. [SQLSTATE 42000] (Error 15404)). The suggestion is that this is permissions related, but I'm not sure where there is a problem as this is a domain admin account. Can someone help to identify where I need to set the permission to query the AD and the SQL database that it needs to access? Thanks
From: John Bell on 20 May 2010 12:15
On Thu, 20 May 2010 08:11:01 -0700, MH39 <MH39(a)discussions.microsoft.com> wrote: >I am trying to schedule a job in SQL 2008 using a proxy however get an error: > >The job failed. Unable to determine if the owner (NICE-PAK\SVC_Sostenuto) of >job Sostenuto AD Import has server access (reason: Could not obtain >information about Windows NT group/user 'NICE-PAK\SVC_Sostenuto', error code >0x5. [SQLSTATE 42000] (Error 15404)). > >The suggestion is that this is permissions related, but I'm not sure where >there is a problem as this is a domain admin account. > >Can someone help to identify where I need to set the permission to query the >AD and the SQL database that it needs to access? > >Thanks Have you tried to change the job owner? John |