November 19, 2004 at 10:15 am
Hi,
I am building a new server :
Win2003(Standard)--> SQL2000EE -->SP3a -->Hotfix589--> SQLReporting Services (SQL RS)--> SQL RS SP1
All SQL Server services starts by the domain account.
After I created maintenance jobs, all jobs failed with the message:
"The job failed. Unable to determine if the owner (DOMAIN\SQLPROD) of job Transaction Log Backup Job for DB Maintenance Plan 'UserDB' has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\SQLPROD'. [SQLSTATE 42000] (Error 8198)).
In the same time jobs run fine as 'sa'. Output message:
"Executed as user: 'DOMAIN\SQLPROD'....
...The step succeeded."
The 'DOMAIN\SQLPROD' account is a member of local admin group, and in SQL Server it has Sysadmin role.
The hotfix 859 did not fix the problem. (http://support.microsoft.com/default.aspx?scid=kb;en-us;821334)
Did enybody have the same issue? Any ideas?
TIA
Leonid
November 19, 2004 at 11:13 am
Hi!
You can use this articles:
http://support.microsoft.com/default.aspx?scid=kb;en-us;241643
http://support.microsoft.com/default.aspx?scid=kb;en-us;834124
Also, check SQL Server and Agent startup account in Services (Admin. Tools). In Windows 2003 this account can couse errors - 'DOMAIN\SQLPROD'. We have, for example, even service startup errors when used old way of credentials. Try to use 'DOMAIN@SQLPROD' .
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply