Creating SQL User

CEOJuice needs a SQL Server Authentication User with DB Owner Rights:

1. Open SQL Server Management Studio and login

2. In the tree on the left, expand Security –> Logins, right click on Logins and select New Login

 3. Type CEOJuice in the login name, change the user type to SQL Server Authentication, Specify a password

4. Uncheck Enforce Password Expiration and change the default database to CEOJuice

5. On the left, choose User Mapping

6. Check the Map check box next to the CEOJuice database, and check db_owner in the bottom pane, third from the bottom. Repeat for live e-Auto database, CoSystem, and Analytics databases.