topic Unable to determine whether database exists. in University Forum

Unable to determine whether database exists.

VarindaSharma — Thu, 07 May 2020 11:40:00 GMT

Please help me in resolving the below issue that I faced while installing trail version of BP(v6.7.1).

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

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.FullInstall(String username, SafeString password)
at AutomateUI.WelcomeWizard.i(Object iml, DoWorkEventArgs imm)

I faced this issue when it is trying to create a local database after finishing installation, launching BP and setting the credentials (username and password). I have checked the prerequisites required to install the software and ensured that my device meets the minimum requirements. I have also made sure that the SQL Server "Allows remote connections to this server," the port is 1433 on Firewall and TCP/IP connectivity is enabled.

------------------------------
Varinda S. Sharma
Software Engineer
Larsen & Toubro Infotech Ltd.
------------------------------

RE: Unable to determine whether database exists.

Jared.Rumball — Mon, 11 May 2020 10:48:00 GMT

Hi Varinda,

The detail of the error message indicates that the SQL Server process itself failed to start:

(provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Error occurred during LocalDB instance startup: SQL Server process failed to start)

Have you verified that the SQL Server service is indeed running and that you can successfully access the local instance (i.e. using SQL Server Management Studio)?

------------------------------
Jared Rumball
Executive Director
Q4 Associates Ltd
Pacific/Auckland
+64211265253
------------------------------

RE: Unable to determine whether database exists.

EduraaP — Tue, 12 May 2020 12:43:00 GMT

Hi Jared, I too have the same problem and SQL server isn't running in my system, the only application is opened is this Blueprism installing process.

------------------------------
Eduraa P
------------------------------

RE: Unable to determine whether database exists.

chris.strong — Tue, 12 May 2020 15:31:00 GMT

Hello Varinda,

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, we provide some further troubleshooting steps.

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

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

RE: Unable to determine whether database exists.

VarindaSharma — Sun, 24 May 2020 17:20:00 GMT

RE: Unable to determine whether database exists.

VarindaSharma — Sun, 24 May 2020 17:24:00 GMT

Hello Jared,

No, SQL service was not running while the installation. When I tried to install MS SQL Server LocalDB manually outside the BP, it still showed me the same error.

------------------------------
Varinda Sharma
------------------------------

RE: Unable to determine whether database exists.

VarindaSharma — Sun, 24 May 2020 17:34:00 GMT

Hi Jared,

Thanks for your reply.

I am following the link to the previous thread provided by you and will try the same steps to see whether that resolves the issue.

------------------------------
Varinda Sharma
------------------------------