BP v6.9 & SQL Express 2014 SP2 Connectivity

[MonishMunot]

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

[chris.mcgowan]

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

[MonishMunot]

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

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

[JerinJose]

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, .*
------------------------------

[chris.mcgowan]

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