Question

Not able to connect to Microsoft SQL server with user define connection mode?

  • 25 March 2022
  • 6 replies
  • 31 views

Hi guys,

I am trying to connect to a Microsoft SQL Server DB with user define connection mode but I got the following error

imagePlease help me how can I connect to the server.

Thank you.


6 replies

Userlevel 5
Badge +8

Hi @Jitendriya Pardia​ ,

 

I think its Port issue from Source and Destination machine via 1434, check with your Network team and then try running the bot in A360.

Hello @ChanduMohammad S​ ,

I have installed the Microsoft SQL server in my local only.

Userlevel 5
Badge +8

Hi @Jitendriya Pardia​ ,

 

Are you passing correct Instance Name?

Yes, I am passing the correct instance name.

Userlevel 5
Badge +8

Hi @Jitendriya Pardia​ ,

 

I'd recommend opening 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.

Userlevel 4
Badge +8

Hi @Jitendriya Pardia​,

 

Thanks for writing to us.

 

Please follow the below steps to resolve the issue:

  1. Download ojdbc.jar file from the Oracle site.
  2. Place the ojdbc.jar file somewhere locally, so we can pass the path of this jar file in the below step.
  3. Within the connect command, check the Use specific database checkbox and select the desktop file option.
  4. While connecting to Oracle, use the following format of connection string: jdbc:oracle:thin:username/pwd@host:port/service_name

 

The service name is the name provided in TNSNames.Ora file which can be different from Instance name(Instance name or SID is the database name).

 

Hope this helps.

 

Regards,

Vijay

Reply