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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-30 : 09:13:28
|
| Stan writes "I am having the following problem. My maintenance plan is failing in SQL 7.0 and SQL 2000. I receive the following error message from the event viewer application log:The job failed. Unable to determine if the owner (OTO\zz888si) of jobDB Backup Job for DB Maintenance Plan 'Test Maintenance Plan' has serveraccess (reason: Could not obtain information about Windows NT group/user'OTO\zz888si'. [SQLSTATE 42000] (Error 8198)).I am on an NT 4.0 network running SQL 7.0 SP3 and SQL 2000 SP2 on Win 2000 Adv Servers adn backing up to the Disk Drive on the server. I am a member of Sysadmin and a Domain Admin.Any assistance you could give me would be greatly appreciated." |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-30 : 11:30:29
|
| set the job owner to sa - this will prevent the error.Can't remember the KB article put there are problems with the PAI used to determine if the job owner has access to SQL when its an NT user. It can also indicate network problems contacting a domain controller.HTHJasper Smith |
 |
|
|
|
|
|
Maintenance Plan Failure