PRB: Error "Client Unable to Establish Connection" When You Open ADO Connection from Within MTS/COM+ Component (300357)
The information in this article applies to:
- Microsoft COM+ 1.0
- Microsoft COM+ 1.5
- Microsoft Transaction Server 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:
- 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.
- 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
| Modification Type: | Major | Last Reviewed: | 2/20/2002 |
|---|
| Keywords: | kbDatabase kbDSupport kbprb KB300357 |
|---|
|