<div>
<div class="content wysiwyg-content">
I have a Windows 2003 server housing a ASP.NET web site accessing a MS SQL 2005 Express DB. Both the website (IIS 6.0) and the DB reside on the same server. The Directory Security in IIS is set to anoynymous login with the local &quot;IUSR_xxx&quot; account. I have the SQL server set to mixed authentication mode and the &quot;IUSR&quot; setup as a login under the SQL Sever Security as well as a Trusted login on the Database it is trying to connect to. The permissions are set to &quot;db_owner&quot;. I've checked the SQL Network Config and verified the Named Pipes and TCP/IP are enabled and running on port 1433 and that there is know application layer firewall blocking the traffic. Yet I still get a &quot;(Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)&quot; Is there something else that I am missing that could be preventing this connection? Thanks in advance<br />
<br />
J
</div>
</div>


I have a Windows 2003 server housing a ASP.NET web site accessing a MS SQL 2005 Express DB. Both the website (IIS 6.0) and the DB reside on the same server. The Directory Security in IIS is set to anoynymous login with the local "IUSR_xxx" account. I have the SQL server set to mixed authentication mode and the "IUSR" setup as a login under the SQL Sever Security as well as a Trusted login on the Database it is trying to connect to. The permissions are set to "db_owner". I've checked the SQL Network Config and verified the Named Pipes and TCP/IP are enabled and running on port 1433 and that there is know application layer firewall blocking the traffic. Yet I still get a "(Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" Is there something else that I am missing that could be preventing this connection? Thanks in advance

J

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.