Error Message - DB String

[Tejaskumar_Darji]

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.



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

[Ben.Lyons1]

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
------------------------------

[Tejaskumar_Darji]

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.




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
------------------------------

[chris.mcgowan · Accepted solution]

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
------------------------------

[Tejaskumar_Darji]

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
------------------------------