You receive a "Could not Connect to Data Source" error message when you open the Transaction Integrator (TI) Manager in Host Integration Server 2004

Article translations Article translations
Article ID: 884384 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you open Transaction Integrator (TI) Manager in Microsoft Host Integration Server 2004, you may receive the following error message:
An error has occurred in CHipTree::SetNamespaceNode

(5006) Could not Connect to Data Source Provider=SQLOLEDB;Server=ServerName;Database=MSHIS60_HIP;Integrated Security=SSPI. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.. Please ensure that the SQL Server specified in the Data Source is running. If you have not done so yet, please run the Configuration Wizard.
When you click OK, you receive the following error message:
Snap-in failed to initialize.
Note When TI Manager opens, you cannot configure any TI objects.

CAUSE

This behavior occurs when Microsoft SQL Server 2000 or Microsoft SQL Desktop Edition (MSDE) is not installed.

RESOLUTION

To resolve this behavior, install SQL Server 2000 or MSDE.

MORE INFORMATION

In Host Integration Server 2004, TI Manager checks for SQL Server configuration and connectivity. Even though only the host-initiated processing (HIP) feature and its components require SQL Server (or MSDE), TI Manager does not differentiate between a Windows-initiated process (WIP) and a host-initiated process (HIP).

TI Manager can use a local or remote SQL Server database. When you use MSDE, you must install MSDE locally on the same server as TI Manager.

For additional information about how to install SQL Server 2000, click the following article numbers to view the articles in the Microsoft Knowledge Base:
303747 How to install SQL Server 2000 basic local installation
814124 How to install MSDE 2000 Security Patch MS02-061 or SP3 with Host Integration Server 2000

Properties

Article ID: 884384 - Last Review: December 4, 2007 - Revision: 1.1
APPLIES TO
  • Microsoft Host Integration Server 2004 Standard Edition
Keywords: 
kbtshoot kbprb KB884384

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com