Hub is unable to connect to SQL Server Express

IgorPetrov — Thu, 23 Feb 2023 16:20:05 GMT

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

Re: Hub is unable to connect to SQL Server Express

JacobClary — Tue, 28 Feb 2023 17:27:56 GMT

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!

topic Hub is unable to connect to SQL Server Express in Product Forum

Hub is unable to connect to SQL Server Express

Re: Hub is unable to connect to SQL Server Express