Creating a Dedicated SQL User (if required)

If for some reasons the customer does not want to give his "sa" user credentials, it is possible to create a user who will be dedicated to SEI. The main benefit is that contrary to a "sa" user who is based on a Windows authentication, the SQL user password does not need to be changed.

To create a SQL user:

1. In a database, expand the Security folder and right-click Logins folder.
2. Select New Login.
3. In the Login Name field, enter a name for your user.

4. Select SQL Server Authentification.
   

   

5. Define a password and specify or not if you want to enhance the password security then leave the remaining fields to their default value.
6. In the Server Roles tab, select sysadmin.
7. In the User Mapping tab, tick the database(s) on which you want the user to have specific roles and choose db_datareader, db_datawriter, db_ddladmin among the roles.
8. Click OK.