topic "unable to determine whether DB exists" in Product Forum

"unable to determine whether DB exists"

BarryBell — Thu, 25 Jul 2019 14:47:00 GMT

Good afternoon, I need some help getting outside vendor access to BP. They are able to get into our server, I have added them as a user in BP but when they are signed in and then launch BP the following error comes up: If I click on "configure" it asks for admin credentials and if I supply them the configure screen comes up but seems to be pointless. The DB and server are valid and connected. Any ideas?

------------------------------
Barry Bell
RPA Manager
DHGLLP
America/New_York
------------------------------

RE: "unable to determine whether DB exists"

tjunicho — Fri, 26 Jul 2019 04:48:00 GMT

Hi,

You might want to check this: https://portal.blueprism.com/system/files/documents/v6.5%20User%20Guide%20-%20Installing%20Enterprise%20Edition.pdf

Unable to determine whether database exists
When testing a SQL connection an error message is displayed:
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:26 - Error Locating Server/Instance Specified)
This is a common error when working with SQL 2008 R2 or later as the server is set up by default to not
accept remote connections. TCP/IP connectivity needs to be enabled for the given instance of SQL Server.
Microsoft provide articles specific to each version of SQL that provide instructions to Enable the TCP/IP
Network Protocol for SQL Server.

You should check the TCP/IP Network Protocol and the port # such as 1433 on Firewall and SQLServerManager settings.

Hope this helps.

------------------------------
Tetsuji Junicho
Manager of RPA Practice Grp.
Accenture Japan
Asia/Tokyo
------------------------------

RE: "unable to determine whether DB exists"

SteveWaters — Fri, 26 Jul 2019 07:52:00 GMT

This could also be an issue with the permissions to the SQL database. Make sure the account you are connecting with has the appropriate rights.

I suggest reading the Provisioning A Blue Prism Database available on the Blue Prism Portal.

------------------------------
Steve Waters
Platform Consultant
Blue Prism Professional Services
America/Chicago
------------------------------

RE: "unable to determine whether DB exists"

BarryBell — Fri, 26 Jul 2019 11:30:00 GMT

Thanks to you both. It was an issue with the user needing to be added to SQL. I assumed it would be automatic when I created the user's profile. Rookie mistake.

------------------------------
Barry Bell
RPA Manager
DHGLLP
America/New_York
------------------------------