Skip to main content
Deutsch 简体中文

How to add Domain users in the SQL DB

  • Updated

Question

 How to add Domain users in the SQL DB. This is necessary to give domain user an DB access, installed on the client, to the SQL Database on a server.

Answer

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

Step 1

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

mceclip0.png

Step 2

Click Search and in locations select Entire directory or domain you want to add the user

 

mceclip0.png

Search for the user

mceclip2.png

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 3

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.