Creating a SQL User

To create a SQL user 1st log in to your eAutomate server and open SQL Server Management Studio.

Start/Microsoft SQL Server/SQL Server Management Studio

Connect to the database as normal

Then go to Security (on left), Logins and choose New Login (note if using an existing user that users starting with ABE will not work as they use Windows Auth.)

Now set up the new user;

1. Create a Username
2. Select SQL Server Authentication
3. Create a password
4. Uncheck "must change password"
5. Go to User Mapping

Pick your eAutomate database and set the Role to db_owner

Then click okay!