08-02-23 08:51 AM
14-02-23 02:14 PM
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.
14-02-23 02:37 PM
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.
14-02-23 02:55 PM
Oh, glad to hear it's working.
Thanks for sharing the root cause.
14-02-23 06:54 PM
Hi @CHOKKAKULAPushp ,
Did you also install SSMS?
07-02-24 12:58 PM
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
------------------------------
07-02-24 01:11 PM
Hello Nagarjuna,
I haven't done SSL setup for SQL as it isn't needed for HUB 4.6.
07-02-24 01:25 PM
Got it, thanks for your quick reply.
13-02-24 09:22 PM
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
------------------------------