topic RE: BP v6.9 & SQL Express 2014 SP2 Connectivity in Product Forum

BP v6.9 & SQL Express 2014 SP2 Connectivity

MonishMunot — Mon, 26 Jul 2021 13:16:00 GMT

Hi All,

We have installed local server, but not able to connect SQL Server with Blue Prism. We are getting error as below

SQL 2014 EXPRESS SP2

BP v6.9

Error: Could not connect to 'LocalBP'.

Unable to determine whether database exists - Could not load file or assembly 'System.Data.SqlClient, Version=4.4.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

Appreciate any helpful pointers.

Thanks!

------------------------------
Monish Munot
------------------------------

RE: BP v6.9 & SQL Express 2014 SP2 Connectivity

chris.mcgowan — Mon, 26 Jul 2021 14:46:00 GMT

Hi Monish,

When you say "local server" do you mean you have installed both Blue Prism 6.9 and SQL Server 2014 Express SP2 on the same machine? If this is the case can you connect to the SQL Server using SQL Server Management studio using the same credentials?

Regards

Chris

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

RE: BP v6.9 & SQL Express 2014 SP2 Connectivity

MonishMunot — Tue, 27 Jul 2021 08:33:00 GMT

I am not able to connect from BP while configuring connection, please refer screenshot.

------------------------------
Monish Munot
------------------------------

RE: BP v6.9 & SQL Express 2014 SP2 Connectivity

JerinJose — Tue, 27 Jul 2021 08:51:00 GMT

Try db server ".\SQLExpress" and give your database name in DB name
when you installed SQLExpress, only if you have enabled windows authentication, then your current configuration should work
check if you can connect to the database using SSMS. Like Chris said same credentials should work

------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
*"If you find this post helpful mark it as best answer, .*
------------------------------

RE: BP v6.9 & SQL Express 2014 SP2 Connectivity

chris.mcgowan — Tue, 27 Jul 2021 10:02:00 GMT

Hi Monish,

Could you test the connection to the Blue Prism database please? I have uploaded an image "TestDBConnection.jpg". If you create a file on the desktop of the machine you are running the Blue Prism client from called TestDBConnection.udl and open it, then enter your server name in the 1. Select or enter a server name: text box, Select the Use Windows NT Integrated Security radio button in the 2. Enter information to log on to the server: section. Once this has been done if you click the 3. Select the database on the server: drop down and you can display a list of databases then connectivity is not the problem. The error message does look like the installation has not been successful and is missing the SQL client assembly.

Regards

Chris

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