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;
- Create a Username
- Select SQL Server Authentication
- Create a password
- Uncheck "must change password"
- Go to User Mapping
Pick your eAutomate database and set the Role to db_owner
Then click okay!