Maintenance Plan

  • Running SQL 2008 Server. The SQL server and Agent services are running as "Local Account".

    I logged into the server as Administrator and then created a maintenance plan to backup a database. When I try to run it, it keeps getting the following error:

    Message

    [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'SERVER\Administrator', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

    This is not a Domain, but a stand alone server. Any help would be great.

    THanks.

  • Is the backup attempting to backup locally or on a network drive/share? This is usually the result of the account which is running SQL not having proper access to the destination backup location.

  • It is trying to backup to a local drive.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply