Since deploying our site to our production servers we have had issues where the site will intermittently load without any content on the page, often with errors in the UmbracoTraceLog along the lines of:
2016-01-22 01:22:51,272 [11] ERROR Umbraco.Core.UmbracoApplicationBase
- [P3088/T1/D2] An unhandled exception occurred System.Data.SqlClient.SqlException (0x80131904): 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) --->
System.ComponentModel.Win32Exception (0x80004005): The network path
was not found at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection, Action`1 wrapCloseInAction)
We are hosting the site on one server with the database on another. The connection string in Web.config points to the database server using an IP address.
We currently have Named Pipes disabled on the database server and are reluctant to enable it if it's not the problem...
Is having Named Pipes enabled/configured a requirement for Umbraco to work in this setup?
I can't see any mention of it in the documentation.
I'm no wizard when dealing with setting up servers and network access etc. - But I don't think it's an Umbraco specific issue since you would get the same connection error if you tried to connect to the database from another application as well. It's a common connectivity issue in general not directly related to Umbraco.
So I'm wondering if it could perhaps be a firewall blocking access perhaps?
We have two other sites running on the same web server which both connect to the same database server. These sites both run fine without connection issues, but they are built with a different CMS which is what led us to believe that Named Pipes being enabled/configured might be an Umbraco specific requirement.
I've seen a few places on "our" where people have speculated that named pipes access is a requirement for remote connection to a database server but nowhere has it been confirmed.
Is anyone able to say one way or another whether named pipe access has to be enabled in order to connect to a remote db server when using Umbraco?
Database Connection Issues (Named Pipes?)
Hi,
Since deploying our site to our production servers we have had issues where the site will intermittently load without any content on the page, often with errors in the UmbracoTraceLog along the lines of:
We are hosting the site on one server with the database on another. The connection string in Web.config points to the database server using an IP address.
We currently have Named Pipes disabled on the database server and are reluctant to enable it if it's not the problem...
Is having Named Pipes enabled/configured a requirement for Umbraco to work in this setup?
I can't see any mention of it in the documentation.
Hi Ash and welcome to our :)
I'm no wizard when dealing with setting up servers and network access etc. - But I don't think it's an Umbraco specific issue since you would get the same connection error if you tried to connect to the database from another application as well. It's a common connectivity issue in general not directly related to Umbraco.
So I'm wondering if it could perhaps be a firewall blocking access perhaps?
/Jan
Hi Jan,
Thanks for your reply.
We have two other sites running on the same web server which both connect to the same database server. These sites both run fine without connection issues, but they are built with a different CMS which is what led us to believe that Named Pipes being enabled/configured might be an Umbraco specific requirement.
Ash
Hi there,
I've seen a few places on "our" where people have speculated that named pipes access is a requirement for remote connection to a database server but nowhere has it been confirmed.
Is anyone able to say one way or another whether named pipe access has to be enabled in order to connect to a remote db server when using Umbraco?
Cheers, Matt
Hi,
Please refer this link:
https://our.umbraco.org/forum/getting-started/installing-umbraco/16230-Unable-to-browse-website-named-pipes-error
hope this help
Regards
Samira
is working on a reply...