topic RE: Cannot connect to SQL DB for Blueprism : No process is on the other end of the pipe in Product Forum

Cannot connect to SQL DB for Blueprism : No process is on the other end of the pipe

ShimaDaisuke — Tue, 10 Dec 2019 04:43:00 GMT

I'm facing issue with connecting SQL from Blueprism. Below are the symptom and points I've checked. I would appreciate if anybody can help me solve the issue. Thank you.

When booting Blueprism (setup for connecting Blueprism Server), "Initializing Connection..." screen comes up and continues forever.
In "Service" screen, "Blueprism Server" service is stopped. It will automatically stop even if I start the service manually.
In "Service" screen, "SQL Server" service is running.
When I try to open the SQL Server Management Studio with Windows Authentication, below message comes up. (partially masked)

When I check event viewer, below "Error" information was logged in Application section. (Source = Blue Prism Server)

Service cannot be started. BluePrism.BPCoreLib.InvalidStateException: Connection not valid: Unable to determine whether database exists - A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - No process is on the other end of the pipe.)

at BPServer.clsBPServer.Start(ServerConfig cfg)

at BPServer.ServerService.DoStart(String[] args)

at BPServer.ServerService.OnStart(String[] args)

at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

No specific change made to server itself nor Blueprism application, when this issue happened. BP was able to connect to server in the morning of this day, and suddenly became unable to connect in the afternoon same day.

------------------------------
Shima Daisuke
Asia/Tokyo
------------------------------

RE: Cannot connect to SQL DB for Blueprism : No process is on the other end of the pipe

jegendra — Wed, 11 Dec 2019 00:46:00 GMT

Hi Shima san,

Where's the SQL Server instance installed? (Inside the Application Server host or Outside on a dedicated SQL Server host)
What type of Server authentication is used under the SQL Server Properties? (Windows Authentication mode or Mixed mode (SQL Sever and Windows Authentication))

------------------------------
Jega Avinasinathan
Customer Support Engineer
Blue Prism
------------------------------

RE: Cannot connect to SQL DB for Blueprism : No process is on the other end of the pipe

ShimaDaisuke — Thu, 12 Dec 2019 01:25:00 GMT

Hi Jega,

Thank you for your response. My answer is as below:
1. SQL server is installed in same machine where Blueprism is installed.
2. We are using Windows Authentication. (OS is Windows Server 2016 Standard)

------------------------------
Shima Daisuke
Asia/Tokyo
------------------------------

RE: Cannot connect to SQL DB for Blueprism : No process is on the other end of the pipe

jegendra — Mon, 16 Dec 2019 06:29:00 GMT

Hi Shima-san,

Please check the following protocols are enabled from the SQL Server Configuration Manager:

Named Pipes
TCP/IP

Also, check the settings to allow SQL Server to accept remote connections.

------------------------------
Jega Avinasinathan
Customer Support Engineer
Blue Prism
------------------------------

RE: Cannot connect to SQL DB for Blueprism : No process is on the other end of the pipe

ShimaDaisuke — Wed, 18 Dec 2019 05:03:00 GMT

Hi Jega,

Unfortunately, I cannot connect to the Database via SQL Server Management Studio, therefore I cannot confirm any setting regarding SQL databases...
As mentioned in my first post, connection is rejected with Error 233, when I click "Connect" in Management Studio (Please see my first post for the detail message).

Is there any other way to confirm the setting through other application?

------------------------------
Shima Daisuke
Asia/Tokyo
------------------------------