Named Pipes Provider: Could not open a connection to SQL Server [53]

[ICI-MASA]

Hi,

we are running a Coldfusion server ver. 10,0,23,302580 which is connected to a MS SQL server ver. 

SQL 2017

And users getting that pages are sporadic not loading with error and we see in the log the following message: 

ajp-bio-8012-exec-304","02/18/21","12:20:23","appControl","Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]Named Pipes Provider: Could not open a connection to SQL Server [53]."

and it can be to any page using a SQL connection. The workaround for the users are to Refresh the page a few times and then they are able to load the page. We do not use Named Pipes on our SQL server. 

We have specified the connection string to be: Server=tcp:dbs-**.***.se;Database=***; to force coldfusion not to use Named Pipes, but for some reason Coldfusion still wants to connect using Named Pipes, how can we disable this?

thanks for any help or tips

best regards

Martin

[BKBK]

Uhm, why don't you solve this by enabling named pipes on SQL Server?

[Dave Watts]

Unless you're actually using Named Pipes to connect to SQL Server from another client, I strongly recommend disabling it in the SQL Server network admin console (I forget what it's called) on the SQL Server box itself. I'm pretty sure that the JDBC client doesn't support Named Pipes at all. For some reason, your database is trying to get it to connect via Named Pipes and that's not going to work.

Dave Watts, Eidolon LLC

[defaultpafb1qcl1bth]

Hi Dave,

thanks for the reply, we are pretty sure that Named Pipes is not enabled on our main database server. We will check that there is no othe linked server that is causing this. But interesting to know that JDBC does not even suppport Named Pipes which leads to the problem to be on the SQL server itself. 

best regards

Martin

[BKBK]

Another suggestion: check whether TCP/IP is enabled on SQL Server.

[BKBK]

What happens when you configure the datasource using just the form provided in the ColdFusion Administrator? That is, without specifying any connection string. For example, as follows:

[Dave Watts]

ColdFusion/JDBC only support connections via TCP/IP as far as I know. That's what the form uses, whether you specify a connection string or not.

Dave Watts, Eidolon LLC

[Charlie Arehart]

Martin, I'm not so sure about your conclusion that cf is using named pipes, based on that error. (I realize that's what it implies. I'm not sure it's what's really happening.) 

Instead, consider first that cf10 is from 2012. I don't think it was updated to support sql server 2017.

But that "support" would be focused on the driver that cf comes with (the "Macromedia" one in the error message).

Have you tried using the free Microsoft jdbc driver? It's easily found and  implemented in cf, if you Google for it. A classic post is this one:

https://www.hass.de/content/coldfusion-10-how-configure-data-sources-microsoft-jdbc-driver-40-sql-se...

And good news for you: he wrote it in the cf10 time frame (but try a later driver).

We could say try a later version of CF also (as cf10 and 11 are no longer supported/updated by Adobe, and now cf2016 support/updates ended this month.) The choices now are cf2018 and cf2021, but I realize some folks will refuse to update. We're here with the bailing buckets and chewing gum to help folks keep old boats afloat.