KB78619044: Automation Engine - How to create a SQL user with administrative privileges

Description

Sometimes we don't know the sa password when needed to create databases in Server Admin. Automation Engine Server Admin only works with SQL users with administrative privileges.

A workaround is to create a new SQL user with administrative privileges.

Procedure

1. Open the SQL Management Studio and login with Windows Authentication with a user who has administrative privileges.
2. Go to Security > Logins and right-click New Login. This opens the Login - New window.
   
3. In the Select a page section, select the General page.
4. In the right pane, type the Login name: (here, sa2).
5. Select the SQL Server authentication option and type the password.
6. Uncheck the Enforce password policy check-box. Click the OK button.
7. Select the Server Roles page in the left pane.
8. In the right pane, select the sysadmin check-box and click the OK button.
   
9. Test the new user by logging in with the new user name and password with SQL authentication.