Create a SQL user account

Last modified by Linus Karlsson on 2023/08/23 15:45

 

IMPACT web services must be able to communicate with the database that was installed in the previous steps. This requires us to set up a user account that these services can use to get read and write access. The user account will use SQL Server authentication.

Create new login

Open up Microsoft SQL Server Management Studio. Go to the Security tab in the Object Explorer, right-click and select New Login...

Logins.png

Figure 5: New login

Under the page General, you choose your Login name and your password. Box SQL Server authentication and unbox Enforce password policy.

Login - general.png  

Figure 6: Page: General

Under the page User Mapping, choose your database and box strusoftServiceRole.

1611061123178-654.png

Figure 7: Page: User Mapping