Database Package in Automation 360 | How to Connect Automation 360 to Microsoft SQL Server

Hi RPA Aspirants,

Welcome to our YouTube Channel EasyWay2Learn.

In this tutorial video, we are showing you a demo Connect Automation 360 with SQL Database using Windows Authentication Mode. Also showing you how to read, update, delete and join tables here in Database Package in Automation 360.

We are covering the following topics in this tutorial video.
• How to connect SQL Database in Automation 360
• How to install JDBC Driver in Automation Anywhere
• How to setup Database Command in Automation 360
• Automation Anywhere Database Connection String

Connection String for SQL Server: jdbc:sqlserver://servername;databaseName=Databasename;integratedSecurity=true

============================================================================
You can also visit our other top RPA Projects and other RPA videos using the below links:
UiPath Tutorials

Automation 360

Automation Anywhere Tutorials

RPA Real Time Projects | RPA Use Cases for Practice | RPA Use Cases for Interview

Automation Anywhere IQ BOT

SAP Automation in Automation Anywhere

==========================================================================

You can also visit our Blog page to read about RPA Interview Questions and Answers.

Thanks,
EasyWay2Learn

[ashwina.k]

Great video as always!

Have you worked with large Excel Data Sets? The best practice according to Automation Anywhere is to connect to it like it were a Database.
Few tutorials on that would be most appreciated.

Kind Regards,
Hsa

[nishanth]

Hi sir, does automation anywhere infrastructure jobs are available in the market, like rpa admin roles apart from developer

[genshinkate]

Hi!
I'm having issues in connecting to sql server. Would you be able to help me? I'm currently using ms sql server(remote desktop connection) with azure mfa as the authentication.

[janellemarismontalbo]

Can you help me?

Error message: Exception occurred in command execution. 'Could not Connect to Database. Cannot open database "SSISDB" requested by the login. The login failed.

[sreeharis]

There was a problem at line 1
This may be due to the following reason:

Exception occurred in command execution. 'Could not Connect to Database. The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".'

Location: MSSQL Database (line 1)


To continue, edit the bot and fix the error. Then, try again.


If you continue to see this message, please contact your system administrator.

Code: bot.execution.error