April 28, 2006 at 9:06 am
I am using a Windows 2003 Login to run a sql job. The Windows 2003 Login is the owner of the Job. The Windows 2003 Login has been assigned to the Windows 2003 Administrators Group. The Windows 2003 Administrators Group has been assigned to the SQL Server Sysadmin Server Role within SQL Server. When the Job tried to execute it returned the following error:
The job failed. Unable to determine if the owner (DomainName\UserName) of job Transaction Log Backup Job for DB Maintenance Plan 'BBDB DB Maintenance Plan1' has server access (reason: Could not obtain information about Windows NT group/user 'DomainName\UserName'. [SQLSTATE 42000] (Error 8198)).
Is there something run with Windows Policy Settings?
We are running SQL Server Standard Edition (sp3) on Windows 2003 EE.
Thanks in advance, Kevin
April 28, 2006 at 3:50 pm
Domain Controller may not be available for the authentication
Regards,Yelena Varsha
May 1, 2006 at 11:48 am
Additionally when looking up the topics to answer the QOD, I found the following for SQL Server 2005 in BOL topic "Execute As Clause (T-SQL)" :
"...........If the SQL Server (MSSQLSERVER) service is running as a local account (local service or local user account), it will not have privileges to obtain the group memberships of a Windows domain account that is specified in the EXECUTE AS clause. This will cause the execution of the module to fail...."
This is also a good example that if SQL Server is running on the local account than domain controller group membership info may not be available to this local account.
Regards,Yelena Varsha
May 2, 2006 at 8:30 am
Start up your mssql , sqlserveragent service accounts with a network account
and add the network account to local admins
regards
wayne
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply