topic RE: Blueprism Hub installtaion-SQL setup in Product Forum

Blueprism Hub installtaion-SQL setup

CHOKKAKULAPushp — Wed, 08 Feb 2023 08:51:00 GMT

Hello, I have been trying to install Blue Prism hub on my machine. While trying to setup the SQL connection, it is showing connection failed. May I know the solution for this. Thankyou.

------------------------------
CHOKKAKULA Pushpa
------------------------------

RE: Blueprism Hub installtaion-SQL setup

alex.oliveira — Tue, 14 Feb 2023 14:14:00 GMT

Hello,

Do you have SQL Management Studio installed on this machine?

I'd start testing the connection to the database, but using SSMS and making sure you're using exactly the same parameters as the ones in the installation.

You can also check the event viewer logs to see if there are any errors poping-up there too.

------------------------------
Alex Oliveira
------------------------------

RE: Blueprism Hub installtaion-SQL setup

CHOKKAKULAPushp — Tue, 14 Feb 2023 14:37:00 GMT

Hi Alex,

Thanks for your response. It seems Hub 4.7 need some SSL setup for SQL, so I tried installing HUB 4.6 and it worked.

------------------------------
CHOKKAKULA Pushpa
------------------------------

RE: Blueprism Hub installtaion-SQL setup

alex.oliveira — Tue, 14 Feb 2023 14:55:00 GMT

Oh, glad to hear it's working.

Thanks for sharing the root cause.

------------------------------
Alex Oliveira
------------------------------

RE: Blueprism Hub installtaion-SQL setup

ManpreetKaur1 — Tue, 14 Feb 2023 18:54:00 GMT

Hi @CHOKKAKULAPushp ,

Did you also install SSMS?

------------------------------
Manpreet Kaur
Manager
Deloitte
*If you find this post helpful mark it as Best Answer
------------------------------

RE: Blueprism Hub installtaion-SQL setup

naga007 — Wed, 07 Feb 2024 12:58:00 GMT

Hi Pusha,

We are facing same issue, but before importing SSL Certificate for SQL DB Server just want to check few things.

BluePrism recommended to use separate DB server for HUB, but as it's PoC for now we are using same BP DB server for HUB setup.
1. If we import SSL, any impact to BP Desktop functionality?

2. Do we need to implement any additional settings for decryption? or any changes needed for BP Desktop setup?

------------------------------
Nagarjuna A
------------------------------

RE: Blueprism Hub installtaion-SQL setup

CHOKKAKULAPUSH1 — Wed, 07 Feb 2024 13:11:00 GMT

Hello Nagarjuna,

I haven't done SSL setup for SQL as it isn't needed for HUB 4.6.

------------------------------
CHOKKAKULA PUSHPA
------------------------------

RE: Blueprism Hub installtaion-SQL setup

naga007 — Wed, 07 Feb 2024 13:25:00 GMT

Got it, thanks for your quick reply.

------------------------------
Nagarjuna A
------------------------------

RE: Blueprism Hub installtaion-SQL setup

wleung — Tue, 13 Feb 2024 21:22:00 GMT

Hello Nagarjuna,

If SQL Server is not configured to "Force Encryption", it should accept both encrypted and unencrypted DB client connection requests. This should allow both Hub's encrypted connection as well as other applications to connect without encryption. Generally, encrypted connections would be a best practice recommendation by default but customers do/can (and I've observed) make a conscientious decision to not not enforce encrypted SQL connections within datacenters.

For BP Enterprise, if secure connection is desired, BP Application Server can be forced to request an encrypted connection to SQL Server. See the following documentation: https://bpdocs.blueprism.com/z-pdf/bpe/install/en-us/blue-prism-7-3-installing-enterprise-edition.pdf. Bottom of page 20, or search for "encrypt=true".

Hope that helps clarify things a bit.

------------------------------
Wing Ling Leung
Senior Product Consultant
Blue Prism Professional Services
------------------------------