Esko Logo Back to Esko Support

Page History

Choose your language for a machine translation:

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3



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.


  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.
Article information
Applies to

Automation Engine all versions

Last revised 
CW NumberCW201891

Table of Contents