Hello all,

Just for those who need it, I was finally able to get a platform running using Azure SQL Databases. How?

1 - Create in Azure portal (or via template, scripting... You pick your poison) the 3 databases (Platform, Logs and Session - from now on, as an example: outsystems, outsystems_log and osState). Be careful to select the correct instance size and collation (CI_AI) as well as other required Azure resources that you might need (Security Groups, vNets, etc.)

2 - Use SSMS to connect to the "master" database of the Azure SQL Server that contains the created databases with your Administrator account and create the required "principals":

CREATE LOGIN OSADMIN
WITH PASSWORD = '<your_OSADMIN_password>'
GO

CREATE LOGIN OSRUNTIME
WITH PASSWORD = '<your_OSRUNTIME_password>
GO

CREATE LOGIN OSADMIN_LOG
WITH PASSWORD = '<your_OSADMIN_LOG_password>'
GO

CREATE LOGIN OSRUNTIME_LOG
WITH PASSWORD = '<your_OSRUNTIME_LOG_password>'
GO

CREATE LOGIN OSSTATE
WITH PASSWORD = '<your_OSSTATE_password>'
GO

3 - Use SSMS to connect to the "platform" database of the Azure SQL Server that contains the created databases with your Administrator account, create the database users and map them to the principals

CREATE USER OSADMIN
FOR LOGIN OSADMIN
WITH DEFAULT_SCHEMA = dbo
GO

-- Add user to the database owner role
EXEC sp_addrolemember N'db_owner', N'OSADMIN'
GO


CREATE USER OSRUNTIME
FOR LOGIN OSRUNTIME
WITH DEFAULT_SCHEMA = dbo
GO

-- Add user to the database owner role
EXEC sp_addrolemember N'db_datawriter', N'OSRUNTIME'
GO
-- Add user to the database owner role
EXEC sp_addrolemember N'db_datareader', N'OSRUNTIME'
GO

4 - Use SSMS to connect to the "log" database of the Azure SQL Server that contains the created databases with your Administrator account, create the database users and map them to the principals

CREATE USER OSADMIN_LOG
FOR LOGIN OSADMIN_LOG
WITH DEFAULT_SCHEMA = dbo
GO

-- Add user to the database owner role
EXEC sp_addrolemember N'db_owner', N'OSADMIN_LOG'
GO


CREATE USER OSRUNTIME_LOG
FOR LOGIN OSRUNTIME_LOG
WITH DEFAULT_SCHEMA = dbo
GO

-- Add user to the database owner role
EXEC sp_addrolemember N'db_datawriter', N'OSRUNTIME_LOG'
GO
-- Add user to the database owner role
EXEC sp_addrolemember N'db_datareader', N'OSRUNTIME_LOG'
GO

5 - Use SSMS to connect to the "session" database of the Azure SQL Server that contains the created databases with your Administrator account, create the database users and map them to the principals

CREATE USER OSSTATE
FOR LOGIN OSSTATE
WITH DEFAULT_SCHEMA = dbo
GO

-- Add user to the database owner role
EXEC sp_addrolemember N'db_owner', N'OSSTATE'
GO

6 - Finally, run the configuration tool.

7 - For each tab on the configuration tool, besides the normal configurations you are used to (server, user names and passwords, etc) in the "Advanced Settings", include the following parameter:

Platform tab: Initial Catalog=outsystems
Log tab: Initial Catalog=outsystems_log
Session tab: Initial Catalog=osState

(The catalog names must match the database names you selected previously for your installation in point 1)

8 - On the Platform and Log tab, test the connections to see if everything is working properly and click "Create and Upgrade database" (grant permissions will not work properly)

9 - On the Session tab, unfortunately, the standard "Create Session Database" won't work no matter what you do. As such, go to File->Generate Session SQL Script and save the SQL file. Open it in SSMS with a connection to the "session" database (see point 5).

Edit the script and remove the section that refers to the creation of the OSSTATE user. I recommend you clear everyting until you find the following comment at around line 51 :

-- HubSessionStateRole 

Execute the whole script after you clear every line before that comment.

10 - Finally!!! Go back to the configuration tool and click "Apply and exit". If you did everything right, the Deployment controller and Deployment service will restart, you will get no errors in the event viewer and Service Center will compile and deploy properly.

Hope this helps.