Trials

last person joined: 13 minutes ago 

Chat about Blue Prism products
Expand all | Collapse all

Learning Edition - Cannot find DB error

  • 1.  Learning Edition - Cannot find DB error

    Posted 10-10-2019 14:41
    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
    ------------------------------


  • 2.  RE: Learning Edition - Cannot find DB error

    Posted 10-11-2019 03:46

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



  • 3.  RE: Learning Edition - Cannot find DB error

    Posted 11-25-2019 12:03
    ​ 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
    ------------------------------



  • 4.  RE: Learning Edition - Cannot find DB error

    Posted 11-26-2019 03:37

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



  • 5.  RE: Learning Edition - Cannot find DB error

    Posted 11-26-2019 11:54
    ​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
    ------------------------------



  • 6.  RE: Learning Edition - Cannot find DB error

    Posted 11-27-2019 05:45

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



  • 7.  RE: Learning Edition - Cannot find DB error

    Posted 12-02-2019 12:40

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



  • 8.  RE: Learning Edition - Cannot find DB error

    Posted 12-03-2019 04:04

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



FAQ

Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.



Share this post