Summary
After upgrading to Automation Engine 14, you get an error when opening Automation Engine Pilot.
Symptoms
After Upgrade, when you try to open Automation Engine Pilot, the following errors appear:


- "An exception occurred while trying to retrieve records:
Problem in StartQuery:"

Solution
Automation Engine cannot open the database tables of all databases (BSJobs, FastLane_TM
)!
To solve, follow these next steps:
- Open SQL Management Studio Express.
- Connect to database instance on the SQL Server where the databases are installed (default on the Automation Engine Server name) with an user with administrative rights,
sa
is default. - On the left, select Security > Logins Properties > admin.
- Double click admin and click Server Roles.

- Uncheck the sysadmin checkbox and click OK.
- Restart Automation Engine Server software with Server Admin.