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.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  SQL Agent jobs not run by the domain account

Author  Topic  zina13 Starting Member 1 Post Posted - 2004-11-19 : 11:40:02 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 (http://support.microsoft.com/default.aspx?scid=kb;en-us;821334) did not fix the problem. Did enybody have the same issue? Any ideas? TIA Leonid