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

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.

Hi @Jitendriya Pardia​ ,

Are you passing correct Instance Name?

Yes, I am passing the correct instance name.

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.

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