Learning Edition - Cannot find DB error

[RashmiChhiber_K]

Hi, 
I just installed learning edition 6.6, but the installation stops when the DB is being installed. I get the detailed error below. Any suggestions on what needs to be fixed?:
"Unable to determine whether database exists - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Error occurred during LocalDB instance startup: SQL Server process failed to start.
)"

------------------------------
RCK
------------------------------

[chris.strong]

Hello Rashmi,

We have had lots of installations of Learning Edition and this is the first time we have seen this error.

It would be useful to have some screenshots so we can see where the setup is failing and any additional information that maybe useful in helping.  I.e. Is there anything special about the computer, like you do not have admin rights to install?

In the meantime, here is some general information that may help troubleshoot the issue.

As a part of the setup of Learning Edition, we do the following:

1. Install the Blue Prism application (It looks like this part is done correctly)
2. Setup a database for you:
   1. Ask you for an admin password
   2. Install Microsoft SQL Server 2017 LocalDB
      1. Tips:
         1. The install file for this is saved (by default) to C:\Program Files\Blue Prism Limited\Blue Prism Automate\Installers\SqlLocalDB.msi
         2. If there has been an issue installing the Microsoft component, you could try to uninstall via Add/Remove programs, open Blue Prism which will then see it is not installed and install it for you.
         3. If that does not work, try installing Microsoft SQL Server 2017 LocalDB manually.

• Create an instance of LocalDB specifically for you and Blue Prism
  1. Tips:
     1. This is called BluePrismLocalDB
  2. Inside the BluePrismLocalDB instance, we create a database called BluePrism

Looking at the error, it reads like either Microsoft SQL Server 2017 LocalDB is not installed correctly or the BluePrismLocalDB instance is not accessible.   The tips above may help you to resolve this, specifically the re-install of Microsoft SQL Server 2017 LocalDB.

I hope this helps and maybe another technical community member will be able to help you further.

------------------------------
Chris Strong
Product Owner
Blue Prism
------------------------------

[AngelaHamilton]

​ I am receiving the same error message. I have attempted to reinstall SQL, but I still receive the same error message. Were you able to resolve this issue?

------------------------------
Angela Hamilton
------------------------------

[chris.strong]

Hello Angela,

Question: Were you receiving the same error when trying to install Microsoft SQL Server 2017 LocalDB manually?

Tip: The install file for this is saved (by default) to C:\Program Files\Blue Prism Limited\Blue Prism Automate\Installers\SqlLocalDB.msi

------------------------------
Chris Strong
Product Owner
Blue Prism
------------------------------

[AngelaHamilton]

​I am still receiving the error even after attempting to install the Local DB manually. When I initially installed the learning edition, I had elevated rights on the machine. However, when I launched the Microsoft SQL Server 2017 LocalDB manually, I made sure there was admin rights during the install. Is there a way to view the SQL Server 2017 LocalDB independently of Blue Prism to ensure it installed correctly?

------------------------------
Angela Hamilton
------------------------------

[chris.strong]

Hello Angela,

For clarity: Did you also receive an error when manually installing Microsoft SQL Server LocalDB 2017?  (I didn't know whether "still receiving the error…" meant you get the error even though you are installing manually)

If you are receiving the error from outside of Blue Prism (whilst installing manually), some suggestions of things to do and check:

1. If you can, share a screenshot so we can see the error in context, this may help us understand where you are seeing the error.
2. Confirm you are using Windows 8.1 or above (LocalDB 2017 does not function on Windows 7)
3. Install Microsoft SQL Server LocalDB whilst logged in as an administrator on your computer.
   • Once it's installed, you can log back in to Windows as yourself.
4. You can confirm it's installed by reviewing your add / remove programs
5. From the command line, type sqllocaldb versions and hit the return key
   • This will list out the versions of Microsoft SQL Server LocalDB installed on the computer
   • Tip: We're expecting to see Microsoft SQL Server 2017 (14.0.1000.169)
6. From the command line, type sqllocaldb info and hit the return key
   • This will list out all the LocalDB instances
   • Tip: We're expecting to see BluePrismLocalDB

------------------------------
Chris Strong
Product Owner
Blue Prism
------------------------------

[AngelaHamilton]

The issue was due to permissions. We uninstalled everything, disabled Avecto, and installed with Admin rights. Once complete, we were able to launch the learning addition. Thank you for your help!

------------------------------
Angela Hamilton
------------------------------

[chris.strong]

Hello Angela,

That is brilliant news and thank you for sharing the steps you took to resolve.

We'll keep an eye out whether Avecto is the common denominator in preventing the Microsoft SQL Server LocalDB 2017 (and therefore Blue Prism Trial and Learning Edition) from working.

Much appreciated

------------------------------
Chris Strong
Product Owner
Blue Prism
------------------------------

[Tejaskumar_Darji]

I too was facing the same error but on the enterprise version.
In my case, the SQL Express service was not running due to port conflict.
Check that your server is up and running. For this open SQL Server Configuration Manager and make sure that your server is running.
If the server is not running then it will keep throwing this error because blue prism is not able to locate the database and connect to it.


Also, you can try disabling TCP/IP and see if that service starts running.


This solution worked for me so I'm dropping down the solution here in case this helps in the future.


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