Skip to main content
Deutsch 简体中文

How to create a SQL User?

  • Updated

Question

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.

Answer

Step 1

Open the SQL Server Management Studio as administrator and connect to the correct instance (in this case myQA).

Step 2

Open the Security tree and right click on Login - choose New Login...

mceclip0.png

Step 3

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.

mceclip1.png

Step 4

Switch to User Mapping, check the repository database and check db_owner as Database role membership. Now the IBA_CSP_REPOSITORY database is mapped.

mceclip2.png

Step 5

Now map the IBA_CSP_REPOSITORY_ARCHIVE database. Check IBA_CSP_REPOSITORY_ARCHIVE and check db_owner as Database role membership.

mceclip3.png

 

Please click here if you want to learn how to assign the created user a sysadmin role.