How to create a new User in the SQL Database? This is necessary to connection Cockpit, installed on the client, to the SQL Database on a server.
Open the SQL Server Management Studio as administrator and connect to the correct instance (in this case myQA).
Open the Security tree and right click on Login - choose New Login...
Fill in the user name, select SQL Server authentication, set a password and un-check Enforce password expiration and User must change password at next login.
Switch to User Mapping, check the repository database and check db_owner as Database role membership. Now the IBA_CSP_REPOSITORY database is mapped.
Now map the IBA_CSP_REPOSITORY_ARCHIVE database. Check IBA_CSP_REPOSITORY_ARCHIVE and check db_owner as Database role membership.
Please click here if you want to learn how to assign the created user a sysadmin role.