Restore to Sql Server using Windows Authentication

Hi, I am getting an error when trying to do a remote restore:

Failed to restore "" database. T-SQL command error: EXEC sp_addrolemember N’db_owner’, N’

User or role ‘****’ does not exist in this database.

the user it refers to is the windows username but I am connecting using Sql Server Authentication.

Why is it trying to use the windows username when connecting with Sql Server Authentication?

The ‘Test Connection’ works perfectly in the ‘Connect to Server’ window.

Any help would be appreciated.

Hi Andy_Brooks,

To resolve the issue please go to your backup job and disable the “Roles and Users” option in the advanced backup job settings.

If you have any other questions, please let us know.

Thank you!