Symptoms

When trying to start Blackpearl service, there will be error like this that is preventing the Service from being started:-
Error 2001 Error Starting Host Server: SQL User manager Error:The ConnectionString property has not been initialized.
Error Invoking 'StartHostServer' : SourceCode.HostServerLib : SQL User manager Error:The ConnectionString property has not been initialized.

 

Diagnoses

There are some changes from infra end where the ports are needed to connect to K2 SQL Server.
 

Resolution

Found out that the Port number format in SQLUM Connection String in HostServer.SecurityLabel table is wrong. The correct format should be:-
SQLInstanceName]:ePortNumber],rK2DBName]

Resolved after correct the format followed by Blackpearl service restart.