Home SQL Protocol Named Pipes is disabled but still periodically getting error "Named Pipes Provider error: 40 - Could not open a connection to SQL Server"
Reply: 0

SQL Protocol Named Pipes is disabled but still periodically getting error "Named Pipes Provider error: 40 - Could not open a connection to SQL Server"

user44987
1#
user44987 Published in September 19, 2018, 9:08 am

I am using a default connection string in a .NET application , not specifying any protocol e.g

<add name="TestConn" connectionString="Data Source=1.1.1.2;Initial Catalog=testDB;MultipleActiveResultSets=True;Persist Security Info=False;User ID=sa;Password=1234; " providerName="System.Data.SqlClient" />

Every so often the error below is logged from the application,

"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: Named Pipes Provider error: 40 - Could not open a connection to SQL Server)"

But on the next connection attempt it continues working as normal connecting successfully. (assuming via TCP)

In SQL Server Configuration Manager under SQL Server Network Configuration Named Pipes is disabled, Shared Memory and TCP/IP are enabled. So why is it even attempting to connect using named pipes ??

The application and SQL server are not on the same machine and i am using the IP address so shared memory shouldnt be used either , so from what i can tell connections should be defaulting to TCP

I dont want to just specify the port in the connection string e.g Data Source=1.1.1.2,1433 or Data Source=tcp:1.1.1.2;

I am trying to understand why its making these attempts?

Am using SQL Server 2008 R2 and a .NET 3.5 console application

share|improve this question
  • 1
    For a non-local connection SqlClient tries TCP first then if that fail it tries NP, only then will if fail (with the error from the NP provider) so this may actually be a symptom of the initial TCP attempt failing. – Alex K. Apr 17 at 12:13
  • even if NP is disabled? should it not fail with a TCP error if it cant connect ? – Rachael M Apr 17 at 13:02
  • Was the sql service restarted after NP was disabled? – DEEPAK LAKHOTIA Apr 22 at 8:27

active oldest votes

Your Answer

StackExchange.ifUsing("editor", function () { StackExchange.using("externalEditor", function () { StackExchange.using("snippets", function () { StackExchange.snippets.init(); }); }); }, "code-snippets"); StackExchange.ready(function() { var channelOptions = { tags: "".split(" "), id: "1" }; initTagRenderer("".split(" "), "".split(" "), channelOptions); StackExchange.using("externalEditor", function() { // Have to fire editor after snippets, if snippets enabled if (StackExchange.settings.snippets.snippetsEnabled) { StackExchange.using("snippets", function() { createEditor(); }); } else { createEditor(); } }); function createEditor() { StackExchange.prepareEditor({ heartbeatType: 'answer', convertImagesToLinks: true, noModals: false, showLowRepImageUploadWarning: true, reputationToPostImages: 10, bindNavPrevention: true, postfix: "", onDemand: true, discardSelector: ".discard-answer" ,immediatelyShowMarkdownHelp:true }); } });
 
StackExchange.ready( function () { StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f49877293%2fsql-protocol-named-pipes-is-disabled-but-still-periodically-getting-error-named%23new-answer', 'question_page'); } );

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged .net sql-server sql-server-2008 sqlconnection or ask your own question.

StackExchange.ready(function(){$.get('/posts/49877293/ivc/c4f0');});
StackExchange.ready(function () { StackExchange.responsiveness.addSwitcher(); }) (function(i, s, o, g, r, a, m) { i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function() { (i[r].q = i[r].q || []).push(arguments) }, i[r].l = 1 * new Date(); a = s.createElement(o), m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m); })(window, document, 'script', 'https://www.google-analytics.com/analytics.js', 'ga'); StackExchange.ready(function () { StackExchange.ga.init({ sendTitles: true, tracker: window.ga, trackingCodes: [ 'UA-108242619-1' ] }); StackExchange.ga.setDimension('dimension2', '|.net|sql-server|sql-server-2008|sqlconnection|'); StackExchange.ga.setDimension('dimension3', 'Questions/Show'); StackExchange.ga.trackPageView(); }); /**/ var _qevents = _qevents || [], _comscore = _comscore || []; (function() { var ssl = 'https:' == document.location.protocol, s = document.getElementsByTagName('script')[0], qc = document.createElement('script'); qc.async = true; qc.src = (ssl ? 'https://secure' : 'http://edge') + '.quantserve.com/quant.js'; s.parentNode.insertBefore(qc, s); _qevents.push({ qacct: "p-c1rF4kxgLUzNc" }); /**/ var sc = document.createElement('script'); sc.async = true; sc.src = (ssl ? 'https://sb' : 'http://b') + '.scorecardresearch.com/beacon.js'; s.parentNode.insertBefore(sc, s); _comscore.push({ c1: "2", c2: "17440561" }); })();
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.316746 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO