How to create an additional MSSQL database user

Additional MSSQL users let you grant application-specific access without sharing the database owner's credentials.

1. Open Databases > Database Users.
2. Select + SQL User.
3. Choose the target database.
4. Enter the username and password, then select the required roles and permissions.
5. Select Create User and update the application's connection string with the new credentials.

An additional-user quota is required. These users are intended for applications and scripts and cannot be used to connect through SQL Server Management Studio.