After installing Automation Engine on a new server for the first time, post installation, the following error appears: "Login failed for user 'sa'".
Post installation, the following error appears: "Login failed for user 'sa'".
When you try to login in to the Pilot the following error appears: "An Exception occured while trying to save the view "admin":BG_EEXception .server.elm.ELM_ENotServicingException:ElemServer not servicing.".
Reason for this error is that there are no databases created post installation because the sa password is not the default sa password, the databases are created in the folder: drive\Esko\bg_data_fastserver_dbase.
There are two solutions:
Modify the sa password temporarily to the default sa password.
Open Microsoft SQL Management Studio Express Edition.
Login to the database Engine with user sa and the password. In the example given below, we are connecting to the unnamed instance.
Go to Security > Logins and double click sa
Type in the new password in the Password and the Confirm password textboxes and click OK.
Open Server Admin > Status overview and do an Activate Server, databases should now be created.
If the sa password is not known, you can create another user with administrative privileges, see