cancel
Showing results for 
Search instead for 
Did you mean: 

Error Message - DB String

Hey Team,

 I installed Decipher on a new machine and I'm seeing the below message in Decipher UI.

Can anybody help with which file/setup do I need to check for DB string.

10130.png

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------
1 BEST ANSWER

Best Answers

Hi Tejaskumar,

This is a known issue, please see the below Support Centre article.

http://portal.blueprism.com/customer-support/support-center#/path/1499878042

Regards

Chris



------------------------------
Chris McGowan
Senior Technical Consultant
Blue Prism
------------------------------

View answer in original post

4 REPLIES 4

Ben.Lyons1
Staff
Staff
Hi Tej,

The configuration file can be found in C:\Program Files (x86)\Blue Prism\Decipher Server and is called 'Ssiserver.exe.config'. You will need to open this as an administrator, likely in Notepad ++ or similar.

There will be a section called 'Connection Strings' where you will see the the current configuration. e.g.

<connectionStrings>
<add name="SsiServerDb" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=DecipherServerDb;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="SsiServerDbReporting" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=DecipherServerDbReporting;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="SsiServerDbPublic" connectionString="" providerName="System.Data.SqlClient" />
</connectionStrings>

Check the respective user access is configured for each database being used (the reporting db is only used in 1.2, so you can ignore that if you're on 1.1).

It's likely that the system user of the new machine needs to be granted access to the db.

Thanks

------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------
Ben Lyons Senior Product Specialist - Decipher SS&C Blue Prism UK based

I've mentioned "." as a default connection string in both config files.
and I checked DB has NT authority permission.
Please check the below image.

10106.png
10107.png
10108.png
The connection string looks ok to me, can you please check.
Is there anything else that am I missing?


------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

Hi Tejaskumar,

This is a known issue, please see the below Support Centre article.

http://portal.blueprism.com/customer-support/support-center#/path/1499878042

Regards

Chris



------------------------------
Chris McGowan
Senior Technical Consultant
Blue Prism
------------------------------

Thanks Chris. The issue got resolved as per the steps mentioned in the above support article link that you provided. Appreciate your help.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------