Hi! To perform database restores, the SQL account must have permissions to create and delete databases, as well as to export and import data. We will look into the issue and get back to you.
That is correct however with Azure SQL, even with all the admin permissions added to the account, it still fails.
n SQL Database, create SQL logins with limited administrative permissions
Create an additional SQL login in the master database.
Add the Login to the ##MS_DatabaseManager##, ##MS_LoginManager## and ##MS_DatabaseConnector## server level roles using the ALTER SERVER ROLE statement.
Here is the output in Veeam if that helps:
Code: Select all
BACPAC import to veeam has failed: Worker VBA-b0d28886-ce9e-4710-b049-665f24fc49b6 (10.76.10.4): job completed with error. Error: Could not import package.
Warning SQL72012: The object [data_0] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Warning SQL72012: The object [log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 15247, Level 16, State 13, Line 5 User does not have permission to perform this action.
Error SQL72045: Script execution error. The executed script:
IF EXISTS (SELECT 1
FROM [sys].[databases]
WHERE [name] = N'$(DatabaseName)')
BEGIN
ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;
END
(trace ID: 94bf6c5b-a3ad-47e4-b071-7ef24ecf9e3f)