BizTalk Server Setup - Config error: Cannot connect to the repository

Author

Config error: Cannot connect to the repository

Robert

2004-05-17, 4:38 pm

I am receiving the following error during the "Current configuration: BizTalk WMI" portion of the configuration process:

Cannot connect to the repository.
OLAP Server: DEVDB
Error: [Microsoft][ODBC Driver manager] Data source name not found and no default driver specified.

When providing the database information during the data entry part of the config wizard, I specified DEVDB as the analysis server and I received no error at that time. (I am using Windows Authentication).

My setup is as follows: DEVDB is the SQL Server and Analysis server. DEVBT is the Biztalk server and Windows Sharepoint Services server. The PivotTable Service components and Decision Support Objects are installed on DEVBT. I am using domain accounts and
groups for the configuration of Biztalk.

Any assistance would be greatly appreciated.

Kevin Chen

2004-05-24, 11:35 pm

Hi Robert,

For BizTalk Server 2004, you must enable network clients DTC access for multi-server deployment configurations. Here is more info about this process:

http://www.msdn.microsoft.com/libra...config_dibn.asp

Also, there are some Troubleshooting tips for BizTalk Deployment at
http://www.msdn.microsoft.com/libra....asp?frame=true

Hope this helps,
Kevin

This posting is provided "AS IS" with no warranties, and confers no rights.

Paul Davidson

2004-06-26, 10:52 am

If running config on DEVBT as a low-privlege user on DEVDB(as SA only with
no machine-permissions for example), verify they belong to olap admin group
on DEVDB.
There's other permissions required as well. Check here:
http://support.microsoft.com/?id=231951
--------------------
Thread-Topic: Config error: Cannot connect to the repository
thread-index: AcQ8TSw47oR901E2RDSRWZCgLMuIBA==
X-WN-Post: microsoft.public.biztalk.setup
From: =?Utf-8?B?Um9iZXJ0?= <anonymous@discussions.microsoft.com>
Subject: Config error: Cannot connect to the repository
Date: Mon, 17 May 2004 13:26:02 -0700
Lines: 12
Message-ID: <73F7A7FE-244B-48B6-B563-020389371C22@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.biztalk.setup
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.setup:3617
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.biztalk.setup

I am receiving the following error during the "Current configuration:
BizTalk WMI" portion of the configuration process:

Cannot connect to the repository.
OLAP Server: DEVDB
Error: [Microsoft][ODBC Driver manager] Data source name not found and no
default driver specified.

When providing the database information during the data entry part of the
config wizard, I specified DEVDB as the analysis server and I received no
error at that time. (I am using Windows Authentication).

My setup is as follows: DEVDB is the SQL Server and Analysis server. DEVBT
is the Biztalk server and Windows Sharepoint Services server. The
PivotTable Service components and Decision Support Objects are installed on
DEVBT. I am using domain accounts and groups for the configuration of
Biztalk.

Any assistance would be greatly appreciated.