Getting error msg when installing Blue Prism Trial and Learning Edition

[StevenFeldman]

An error occurred whilst configuring Blue Prism localdb.
BluePrism.DatabaseInstaller.DatabaseInstallerException: 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.
)
at BluePrism.DatabaseInstaller.Installer.CheckDatabaseExists()
at BluePrism.AutomateAppCore.LocalDatabaseInstaller.get_DatabaseExists()
at BluePrism.AutomateAppCore.LocalDatabaseInstaller.get_UpgradeOnly()
at AutomateUI.BPApplication.Start(String[] args)

------------------------------
Steven Feldman
------------------------------

[chris.strong]

Hello Steven,

We saw this back in October 2019 on another thread (Learning Edition - Cannot find DB error) and it seemed the root cause of the issue was down to not having the right permission to install and setup Microsoft SQL Server LocalDB 2017.

I'll stick to the previous guidance, which was confirming whether Microsoft SQL Server LocalDB 2017 is already installed, if not, attempt to install it manually outside Blue Prism.  Based on this information, we provided some further troubleshooting steps.

Tip: See the comments on 11 October and 27 November 2019.

In Summary: We're seeing a Microsoft SQL Server LocalDB error, we're trying to determine whether that same issue appears without Blue Prism being involved, this will help troubleshoot.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

[StevenFeldman]

Chris,

I am still struggling with resolving this issue. When I walk through the installer it does allow me to get to these steps of Configuring and activating. MS SQL 2017 is installed on my PC. Since I am very technical I am not sure what I need to do next? Are you, by chance, available for a 15-minute telephone conversation?

--

Steve Feldman

+1 908 672-5584 (mobile)

sdfeldman54@gmail.com

[StevenFeldman]

Chris,

Have made some progress. I was able to correct a couple of MS SQL 2017 configuration parameters and was able for the Blue Prism installer to create the database, etc. Looks like the last issue is installing the license file. The big issue that I have is when I open the BluePrism application, it does not present me with a login screen nor any mechanism to administer (e.g. add a license file) the application any further.

The only time the BluePrism installer prompted me for a login and password was after I removed MS SQL 2017 off of my computer and attempted to reinstall BluePrism.

What I am experiencing does not follow the installation guide. Any help is appreciated.

Regards,

Steve
+1 908 672-5584 (mobile)
sdfeldman54@gmail.com

------------------------------
Steven Feldman
------------------------------

[chris.strong]

Hello Steven,

Sorry to hear you are still struggling.

When you open Blue Prism, what do you see?

I expect you to be able to see, a Blue Prism login screen (screenshot) below.  On here you can enter the user name admin and the password that you created yourself (just before we create the database for you).

Then, once you login, Blue Prism will detect that you don't have a license and then guide you through applying a license to your copy of either Blue Prism Trial or Learning Edition.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

[StevenFeldman]

Chris,

No. The login screen never appears. First I get the Blue Prism screen:

Then, after about 10 seconds or so:

I resolved some of the MS SQL 2017 settings issues on my own. I then had to use Windows File Explorer to navigate to the "SQLLocalDB" and "Automate Config" installation files. I clicked on it, put in the proper settings, and was able to create the database and establish connectivity to it.

--

Steve Feldman

+1 908 672-5584 (mobile)

sdfeldman54@gmail.com

[chris.strong]

Hello Steve,

Thank you for letting us know you worked around the issue.  Looking at your screenshots, I think you've switched to using MS SQL Server Express, rather than LocalDB.  That will work. 

We made a conscious decision to keep the Learning Edition simple for non-techie people, that's why we choose to use LocalDB, as we can (should be able to) deploy and setup automatically, without complex configuration.

Now you're up and running, I hope you enjoy your learning experience.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

[StevenFeldman]

Chris,

Actually, I'm not out of the woods yet. Still having issues. I can't log onto BluePrism. No mechanism to install license.

Sent from my iPhone

Steve Feldman Innovation and Customer Experience 

Group - Self Service Practice Leader

+1 908 953-6436 office +1 908 672-5584 mobile

sdfeldman@Avaya.com

"Delivering Value & Vision through Customer Experience Solutions"

[chris.strong]

Hello Steven,

Oh no, sorry I misunderstood your post.

Let's first check if I've followed, this is what I think you have:

1. Microsoft SQL Server 2017 LocalDB is not working on your computer (we keep seeing error messages when attempting to connect to it)
2. You have installed Microsoft SQL Server Express (I don't know which version, but that shouldn't matter here)
3. You have created a new Blue Prism database:
   • Database Server: localhost\SQLExpress
   • Database Name: BluePrism
4. You have added a Connection to the Blue Prism application and called it BPConnection
5. You have not logged into to you BPConnection Blue Prism database

If I've understood / assumed correctly, this is the behaviour I expect you'd see:

1. You should now be able to open Blue Prism and be presented with Sign in to Blue Prism (I've created a screenshot below)
2. Based on your screenshot, I expect you to have a drop down listing LocalDB Connection and BPConnection
3. If you select BPConnection (the one you manually created), by default, the username will be admin and the password will be admin
4. Once you login using admin / admin, you will be asked to give the admin username and new password (so that it doesn't stay at the default)
5. Once you change the password, Blue Prism will detect that there is not a license within your new database and prompt you to license it.
   • Note: Each database is licenses individually, you will not be prompted to license the Blue Prism database until you've opened it within the application.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

[StevenFeldman]

Chris,

The issue that remains is that when I click on the Blue Prism application icon on my desktop the login screen never appears. First I get the Blue Prism screen:

Then, after about 10 seconds or so:

So, I never get a screen that allows me to log in and complete the remaining tasks.