Support Portal

for ProcessRobot and WinAutomation

Start a new topic
Answered

ProcessRobot server connectionstring Azure SQL

What is does the connectionstring for Azure SQL look like for ProcessRobot server?


Also I get an error that the database upgrade was not succesfull. If I look in the log file it says that "Statement 'BACKUP DATABASE' is not supported in this version of SQL Server". After some searching on the internet, Azure SQL does not support this. How to workaround this if you want to use Azure SQL with ProcessRobot?


Best Answer

Hi Robin,

I use the following connectionstring to connect with Azure SQL:


Server=tcp:<name_server>.database.windows.net,1433;Initial Catalog=<db_name>;Persist Security Info=False;User ID=<user>;Password=<pass>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=60;


<name_server> - name server from https://portal.azure.com

<db_name> - db name from https://portal.azure.com

<user> - Username to DB

<pass> - Password to DB


I hope I helped a little :)

1 Comment

Answer

Hi Robin,

I use the following connectionstring to connect with Azure SQL:


Server=tcp:<name_server>.database.windows.net,1433;Initial Catalog=<db_name>;Persist Security Info=False;User ID=<user>;Password=<pass>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=60;


<name_server> - name server from https://portal.azure.com

<db_name> - db name from https://portal.azure.com

<user> - Username to DB

<pass> - Password to DB


I hope I helped a little :)

Login or Signup to post a comment