Question

SQL connection issue with existing user and newly created database.

  • 10 October 2022
  • 4 replies
  • 70 views

The SQL server throws out the error when we trying to setup A360 IQBot on premise server.

 

"Login failed for user [existing user]. Reason: Failed to open the explicitly specified database [Database Name]. [CLIENT: [Private IP Address]]"

 

I have tried setup using the sa account credential also getting the same result.

 

Anyone also facing this issue?


4 replies

Userlevel 6
Badge +9

Hello @Zhen Yi Koh​  You may test the SQL Connectivity issue from your IQBot server. Follow https://learn.microsoft.com/en-us/troubleshoot/sql/connect/test-oledb-connectivity-use-udl-file

Userlevel 5
Badge +12

Hi @Zhen Yi Koh​ ,

 

I'd recommend you to connect with your DB team they can help you out on checking the connectivity issue. Also please refrain putting sensitive information like IP in this pubic forums.

 

Also open a support ticket with AA using below link

 

https://apeople.automationanywhere.com/s/support/p>

 

if you don't have access to the above link, Send an email to AA Support team "apeopleopsteam@automationanywhere.com" to get the access.

Sadly our company DB team is me and only me. 😶

Follow the below steps to see if you can resolve the issue.

Step 1 - Check that you can ping the SQL Server box.

Step 2 - Check that the SQL Services are running.

Step 3 - Check that the SQL Server Browser service is running.

Step 4 - Check that you are using the correct SQL Server instance name.

 

Regards,

Rachel Gomez

Reply