Home > Clients, Software, Windows Server > MS SQL Server local file backup problem resolved

MS SQL Server local file backup problem resolved

I recently ran across a problem twice with backup maintenance plans in Microsoft SQL Server (2000+). The following error started to appear when the file backup job started to run:

… – Message: The job failed. Unable to determine if the owner (DOMAIN\Administrator) of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\Administrator'/ [SQLSTATE 42000] (Error 8198)).

There seemed to be lots of people with the same problem but no solutions offered. Here's the solution that worked for us:

  1. Go to Administrative Tools -> Services. Click on SQLSERVERAGENT and select Properties from the Action menu. Click on the Log On tab. Select Local System Account. Click on the General Tab. Select Startup Type: Automatic and hit OK.
  2. In Enterprise Manager, go to Maintenance, and click on SQL Server Agent. Select Properties from the Action menu. Click on the Connection. Select Use Windows Authentication and hit OK (You may need to stop and restart the SQL Server service at this point).
  3. In Enterprise Manager, click on the name of the local server and select Edit SQL Server Registration properties… Select Use SQL Server Authentication (we used sa), and hit OK
  4. Delete the existing database plan and create a new one.
Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: