We must ensure that the technical user we create can connect to the MS SQL Server using Windows Authentication, and that the user has the DBCREATE privilege on the MS SQL Server.
Create login (MS SQL script)
Grant the technical user the DBCREATE privilege on the MS SQL Server (replace 'yourservername' with the name of your Windows server). MS SQL script (run as a database administrator):
USE [master];
GO;
CREATE LOGIN [yourservernameoddc_techuser] FROM WINDOWS WITH DEFAULT_DATABASE = [master], DEFAULT_LANGUAGE = [us_english];
GO;
ALTER SERVER ROLE [dbcreator] ADD MEMBER [yourservernameoddc_techuser];
GO;
