SQL 2000 Maintenance Plan Not Running

[CBrianC]

I have a scheduled maintenance plan on SQL 2000 on a Windows NT server. All SQL services are set to log in as System Account. When the plan tried to run, I get this message in the App log: The job failed. Unable to determine if the owner (XXX\Administrator) of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan 1' has server access (reason: Could not obtain information about Windows NT group/user 'XXX\administrator'. [SQLSTATE 42000] (Error 8198). Primary domain controller is Windows 2000 Server.

Thanks,

Brian Chalmers

 

[TitleistDBA]

It sounds like who ever has logged into the system account does not have access to execute the pakage. You are better of doing the following to prevent this in the future.
Create a domain account, add that domain account to the Administrators group on the server. Run the SQL services and SQL agent on that domain account.
You should also set that domain account password to never expire and user can't change password. If you can't do that log into the server as an admin or the owner of the maint plan and run it.

http://www.acushnetcompany.com

 

[CBrianC]

Does this domain account also need a login in the Security section of Enterprise Manager?

 

[TitleistDBA]

SQL will put it there by default. To change your account follow these steps.

Right click on server name in Enterprise Manager
select Properties
select the security tab
in the startup service account put domain\login and password.
Click OK. SQL will have to refresh the services so If you are running an app that can't have any downtime during the day you should schedule this change.

You will also want to drill down to the sql server agent and right clikc on it and select properties.
On the general tab put the same info as you did for the server properties.
The SQL agent will also need to be refreshed.

http://www.acushnetcompany.com