How can we help you today? How can we help you today?

sql error 916

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?


Thanks.
oberion
0

Comments

2 comments

Sort by
  • petey
    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.
    petey
    0
  • oberion
    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.
    oberion
    0

Add comment

Please sign in to leave a comment.