Microsoft KB Archive/303453

= BUG: Setup and BizTalk Messaging Service Fail When You Connect to a Clustered SQL Server =

Article ID: 303453

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft BizTalk Server 2000 Standard Edition

-



This article was previously published under Q303453



SYMPTOMS
When you attempt to connect BizTalk Server to a clustered Microsoft SQL Server computer, the BizTalk Server Setup program and the BizTalk Messaging Service fail, and the following error message occurs:

CIS_E_ADMIN_DBCONNECT - &quot;BizTalk Server failed to access the &quot;%1&quot; database on the &quot;%2&quot; server with the database connection information.



CAUSE
The error message is the result of an Access Denied message that is returned by the SQL Server OLEDB Provider. The Access Denied error message occurs because all attempts to connect to the clustered SQL Server computer are done by using Windows NT Authentication instead of SQL Server Authentication, which is what the BizTalk Server Setup program is attempting to use.



RESOLUTION
Install Microsoft Data Access Components (MDAC) 2.7 on the BizTalk Server computer that will connect to a clustered SQL Server computer.



STATUS
Microsoft has confirmed that this is a problem in BizTalk Server 2000.



MORE INFORMATION
For more information about Microsoft Data Access Components (MDAC), see the Microsoft Universal Data Access Web site:

http://www.microsoft.com/data/default.htm

Keywords: kbbug kbfix KB303453

-

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

© Microsoft Corporation. All rights reserved.