Changed Administrator Logon name, SQL Backup refuses to work 1

[jlgdeveloper]

The administrator logon was recently changed from administrator. Sql works properly except for the maintenance plans. Both the SQL Server and the SQL Server Agent are logged on under the new administrator name. The backups refuse to run, with the following error:

(reason: Could not obtain information about Windows NT group/user 'BHG\Administrator'. [SQLSTATE 42000] (Error 8198)).

I have deleted and recreated the backup job after restarting everything with the new logon. I want to avoid reinstalling SQL Server.

Any Ideas?

 

[tlbroadbent]

Check the owner of the Jobs. They are proably owned by Admininstrator. Change to a new owner.

In my opinion, you shouldn't be running SQL Server and SQL Agent with the main NT Administrator login. SQL Should have it's own login. SQL Agent can run on the same login or a dfferent login. These logins should be Local Administrators. They should also be domain users if accessing mail or folders and files in other servers. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[jlgdeveloper]

Terry

Problem Solved.
I appreciate your advice.
I tried changing the job owner name, sql would never accept the new owner even though it was available in the dropdown. I created a new job form scratch with the new owner. It reverted to the old administrator account, and so would not work.
I added a new nt user called administrator.
Everything worked (in this new user account), and I have the new user in the backup operators group only.
The sql service and agent are back to the system logon. I only had them start in the current administrator account for troubleshooting purposes.
I had not noticed that jobs had an owner.

I hope the new user "administrator" will not interfere with the "built in administrator" account of a different name.

Thanks for the help.

Jonathan