What are the challenges you face when working across database platforms? Take the survey

sql error 916

oberionoberion Posts: 41
edited January 20, 2006 1:06PM in SQL Backup Previous Versions
I am trying to do a backup via the GUI after importing my sql group structure from SQL Enterprise Manager.

I get the following errors at the end:

sql error 916: Server user 'NT AUTHORITY\SYSTEM' is not a valid user in the database 'DB_NAME'

I am looking at the authenication method and it is using Windows authenication now ... any thoughts on how to resolve this?



  • Options
    peteypetey Posts: 2,358 New member
    Please check the SQL Backup Agent service user. It needs to be a user account that has the SQL Server sysadmin fixed server role.

    By default, the service is set up to run using the LocalSystem account, and I guess that that's been locked out of your SQL Server.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Petey, thanks for the info.

    Spoke with Brian D. about this on the phone and I asked why there wasn't a prompt asking us to use to local system account or enter a different account for this service.

    Hopefully in the next upgrade this will be incorporated? Because changing 40+ windows services doesn't sound like fun to me.
Sign In or Register to comment.