Open the Microsoft SQL Server Management Studio application.
Note: These steps can be performed on any computer/server that has access to Management Studio
Connect to the SQL Server that hosts the ‘FworkSQLEcm’ database
From the Folder list on the sidebar, right click on the Security option and select New → Login
Image AddedEnter the required details on the General tab
Ensure to record these details, as you will need them during the setup of the Connector.
Select the SQL Server authentication option
Enter a Login name
Enter a Password
Untick the ‘Enforce Password Policy’ option
From the User Mapping tab, select the FworkSQLEcm database, and tick the db_owner option
The minimum database security options are available here:
Database Security Considerations - Framework - Confluence
Press OK to create the SQL Authentication account