To create a SQL Server login that uses SQL Server Authentication:

1. In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.

2. Right-click the Security folder, point to New, and then click Login.

3. On the General page, enter a name for the new login in the Login name box.

4. Select SQL Server Authentication.

5. Enter a password for the login.

6. Select the password policy options that should be applied to the new login. 'Enforce password policy' may be turned off for now.

7. Select default database to ACEN database.

8. Select 'User mapping'

9. Select ACEN database in 'Users mapped to this login:" list.

10. Select 'db_backupoperator', 'db_datareader' and 'db_datawriter' options in 'Database role membership list for '

11. Click on 'OK'

Knowledge base