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.