Data - SQL Server VBO / how to define the connection through the BP server application

[FlorianGosselin]

​Hi All,

I have a server A with SQL database, a server B with BP server. The server B comnunicate with the server A.
My Runtime ressource communicate only with the server B.

I would like to use the VBO Data - SQL Server but i don't know how configure connection string to use because i can't call directly the SQL database.
if i create a connection directly with server A, it's work only when it is executed from server B but not from Runtime.

Do you know how to write the connection string to use the BP server application instead of server and name of SQL database ?

Thanks!


------------------------------
Florian Gosselin
Developper
Accenture Technology Solutions
Europe/Paris
------------------------------

[VivekGoel]

I guess you are trying to run the SQL query on BP Database itself from the run time resource which is not advisable.
BP App Server name is internal to BP and SQL server VBO accepts alias or hostname or Ip to configure the connection as per basic dotnet guideines.

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
https://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------