Search code examples
windows-server-2012sql-server-2017automationanywhere

Failed to start Automation Anywhere Control Room: Bad Gateway

After I installed Automation Anywhere 11 with SQL Server 2017 on windows server 2012, I could not launch the control room getting bad gateway message.

Could anyone help identifying the problem??

Solution

  • There are several possible reasons for this to happen, the one most easy to miss is your SQL login not having permissions to access your DB.

    Open your SQL Management Studio and check that your have login logging enabled (Server Properties -> Security -> Login auditing). It is set to Failed only by default, you can change it to Both successful and failed if you wish.

    enter image description here

    Then attempt to login to Control Room and then check the logs.

    enter image description here

    You are most likely going to see an account trying and failing to connect to the DB. Give that account sufficient privileges and try again.