<div>
Check this post:<br />
<a href="http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/" rel="ugc">http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/</a>
</div>


Check this post:
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/ [http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/]

<div>
I just enabled the Named Pipes services as per comment and it is working now.<br />
<br />
Thanks for your comment and you can close the case
</div>


I just enabled the Named Pipes services as per comment and it is working now.

Thanks for your comment and you can close the case

<div>
<div class="content wysiwyg-content">
I just installed TMG2010 on Windows std 2008 64bit Sp2 platform then installed GFI Webmontor as add-on on this. But while I configure SQL Database connection from GFI to SQL server, it shows Name Pipes provide error:40 &quot;Could not open connection to SQL server.<br />
<br />
When i checked on SQL server NamedPipe, TCP/IP, Shared Memory are enabled and unable to telnet from TMG server to SQL server.<br />
&nbsp;<br />
pls help me to resolve the issue...
</div>
</div>


I just installed TMG2010 on Windows std 2008 64bit Sp2 platform then installed GFI Webmontor as add-on on this. But while I configure SQL Database connection from GFI to SQL server, it shows Name Pipes provide error:40 "Could not open connection to SQL server.

When i checked on SQL server NamedPipe, TCP/IP, Shared Memory are enabled and unable to telnet from TMG server to SQL server.
 
pls help me to resolve the issue...

SQL DB port access from a TMG server

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Microsoft Forefront, formerly known as Internet Security and Acceleration Server (ISA Server), is a network router, firewall, antivirus program, VPN server and web cache that runs on Windows servers. It includes identity management and protection systems, and discontinued systems for threat management and network protection, along with protection for Sharepoint and Exchange. The scope of discussions includes forward and reverse proxy, application and service publishing, virtual private networks (VPNs), outbound access rules, SSL certificates and network routing within either a single node or an highly-available array pairing.

Microsoft Forefront ISA Server

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.