Info
The Datical Packager process requires elevated privileges on a REF Azure SQL Database as an ephemeral database is created and dropped as part of the Backup and Restore operations. The below instructions show how to setup separate Logins and Users for a REF database versus a non-REF database.

Create a REF Datical Login and User

Make sure that you are connected to the master database as the Server admin and use the master database to run commands:

...

Info
The default Azure password complexity rules are the following: minimum length of 8 characters, minimum of 1 uppercase character, minimum of 1 lowercase character, minimum of 1 number.

Create a REF Database User

Create a user (datical_ref_user) for a database where Packager operation will be performed:

...

Code Block
CREATE USER [datical_ref_user] FOR LOGIN [datical_ref_login]; EXEC sp_addrolemember 'db_owner', 'datical_ref_user';

Make sure that you are connected to the master database as the Server admin and use the master database to run commands:

...

Info
The default Azure password complexity rules are the following: minimum length of 8 characters, minimum of 1 uppercase character, minimum of 1 lowercase character, minimum of 1 number.

Create a user (datical_user) for database where Forecast and Deploy (not Packager) operations will be performed:

...