Post reply

Maintenance Plan

  • October 2, 2008 at 3:14 pm

    #154782

    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.

  • October 2, 2008 at 6:13 pm

    #880241

    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.

  • October 3, 2008 at 8:17 am

    #880488

    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