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

New Here ,
Feb 19, 2021 Feb 19, 2021

Copy link to clipboard

Copied

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

TOPICS
Database access, Documentation, Server administration

Views

97

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Feb 19, 2021 Feb 19, 2021

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Feb 19, 2021 Feb 19, 2021

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 22, 2021 Feb 22, 2021

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Feb 22, 2021 Feb 22, 2021

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Feb 23, 2021 Feb 23, 2021

Copy link to clipboard

Copied

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:

 

BKBK_0-1614112656704.png

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Feb 23, 2021 Feb 23, 2021

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Feb 23, 2021 Feb 23, 2021

Copy link to clipboard

Copied

LATEST

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. 


/Charlie (server troubleshooter, carehart.org)

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines