Microsoft KB Archive/300357

= PRB: Error &quot;Client Unable to Establish Connection&quot; When You Open ADO Connection from Within MTS/COM+ Component =

Article ID: 300357

Article Last Modified on 12/5/2007

-

APPLIES TO


 * Microsoft COM+ 1.0
 * Microsoft COM+ 1.5
 * Microsoft Transaction Services 2.0

-



This article was previously published under Q300357



SYMPTOMS
When you open an ActiveX Data Objects (ADO) connection from within a Microsoft Transaction Server/COM+ component, you may get the following error message:

[Microsoft][ODBC SQL Server Driver]Client Unable to Establish Connection



RESOLUTION
To resolve this problem, make sure that you have TCP/IP rather than named pipes selected as the default network configuration for SQL Server. To set TCP/IP as the default network protocol for the database connections, follow these steps:
 * 1) On the client computer, click Start, point to Programs, point to Microsoft SQL Server, click Client Network Utility, and then click General. Add TCP/IP to the protocol list.
 * 2) On the server computer, click Start, point to Programs, point to Microsoft SQL Server, click Server Network Utility, and then click General. Add TCP/IP to the top of the protocol list.

Alternatively, you can append the following to the database connection string: Network=dbmssocn

Keywords: kbdatabase kbprb KB300357

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.