23-02-23 04:20 PM
Good day, folks!
Context: I am trying to evaluate Blue Prism platform. To be more specific: I would like to explore integration options with the Blue Prism API. While I haven't found how to just install stand-alone BP API, I am currently following the whole installation process. Currently, I am stuck with the HUB installation as it refuses to connect to the SQL Server.
Are there any hints how can I see logs or any hints why doesn't it connect?
What I did so far:
- Tried multiple value combinations of the field "Please select SQL Server": explicit DB server name, IP address, IP address with suffix `tcp:`.
- Creating both new users, as well as enabling `sa`. Both were able to connect through the SQL Server Management tool but not during HUB setup.
- Created ad-hoc python script to make sure that I can still establish connection from outside world. My resulting working `pyodbc` connection string: `'DRIVER={ODBC Driver 17 for SQL Sever};SERVER=tcp:xxx.xxx.xxx.xxx;DATABASE=MyDB;UID=MyUser0;PWD=XXXXX'`
At this moment, my only guess is that HUB installer requires SQL Server connection to be SSL-encrypted but I haven't found references at docs page.
Tools:
- Windows Server 2019
- SQL Server Express
- BluePrism 7
- BluePrism HUB 4.4.1
PS. Alternatively, I would consider suggestions to bypass HUB installation and go directly to BP API, even if mocked version.
Thank you!
Best,
Igor
28-02-23 05:27 PM
Hey Igor, I hope you are doing well today.
I can confirm that the SQL Server connection needs SSL for the connection to work. You can see that requirement in this part of our documentation here.
I hope that helps to clarify the installation errors you're experiencing!