Remote server restore fails:

Application issues
1

remote server restore fails:

Restoring “BCSTEST” database from files: “BCSTEST201808270956.sql”
8/27/2018 10:08 AM Failed to restore BCSTEST database. Failed to run T-SQL command: GRANT CONNECT TO [pfi] AS [dbo]

of course we do not have a user pfi but have the usual SA account . do not see a way to tell the script to use SA or cannot modify the script as when I load the script into SSMS an exception is thrown by SSMS

2

Hi John,

Thanks for the details, please give us some time to check this case.

We have in our plans to add an option for remote backup that will allow excluding users. Currently, as a workaround you can remove the following sentences from your scripting:

GRANT CONNECT TO [pfi] AS [dbo]

Sorry for the inconvenience.