Updated by EskoConfluence integration from workflowwiki
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 BGSYSTEMsapassword, 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 BGSYSTEMsapassword.
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
Content by Label
Create the databases in the Server Admin:
Open Server Admin.
Login in to Server Admin with User nameadmin and default password admin.
Click the lock icon to login to the SQL server instance with user sa and corresponding password or an user with administrative privileges on the SQL Server.
Create the databases by clicking the + sign.
Enter BSjobs for the Database name.
In the Use data drop down menu, choose No (empty database).
Click on browse to the folder where the Master database file must be stored, default drive\Esko\bg_data_fastserver_dbase, and click ok
Click Browse and go to the folder where the Transactionlog file must be stored, default is drive\Esko\bg_data_fastserver_dbase and click OK.
Click OK, database will be created.
Repeat the steps for the FastLane_TM and FastLane databases.
In Suite 12.2 there will be the possibility to specify another sa password.