|
Home > Archive > BizTalk Server General > May 2004 > BizTalk 2004 Configuration on REMOTE SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BizTalk 2004 Configuration on REMOTE SQL Server
|
|
| Kumble 2004-05-24, 4:37 pm |
| Hi
I am insatlling BTS 2004 on computer1 and SQL Server 2000 (includes latest SP's and SQL ANalysis services and its SP3a)
What are the pre-requisites for configuring BTS 2004 that would create BTS Databases on remote SQL Server.
When I configure by giving remote SQL Server, it is throwning an error for BizTalkMgmtDB saying unable to find columnid etc.,
Also If I select configure BAM aggregation 2nd step in BTS configuration, when configuring DB it throws Provider error.
Please help.
Thanks in advance
| |
| Matt Milner 2004-05-24, 4:37 pm |
| Make sure your DTS is setup on both machines to allow distributed
transactions. I think you can set this in Add/remove programs. This is
required to do transactions to SQL.
Also, make sure you have the client tools for Analysis services on your
server as they are needed to install the analysis services things remotely.
Matt
"Kumble" <anonymous@discussions.microsoft.com> wrote in message
news:97354731-AEDB-4E8B-B825-632D9BAAF079@microsoft.com...
> Hi
>
> I am insatlling BTS 2004 on computer1 and SQL Server 2000 (includes latest
SP's and SQL ANalysis services and its SP3a)
>
> What are the pre-requisites for configuring BTS 2004 that would create BTS
Databases on remote SQL Server.
>
> When I configure by giving remote SQL Server, it is throwning an error for
BizTalkMgmtDB saying unable to find columnid etc.,
>
> Also If I select configure BAM aggregation 2nd step in BTS configuration,
when configuring DB it throws Provider error.
>
> Please help.
>
> Thanks in advance
| |
|
| Matt,
we have also same problem. We are not able to deploy BAM excel with m.exe. It gives us olways "query interface error".
under add/remove programs, there is only DTC and this one is enabled.
We have SQL client utilities. enterprise managr and analysis manager are working I can connect and query the databases.
any ideas, thanks in advance,
-metin
| |
| Matt Milner 2004-05-24, 11:35 pm |
| Depending on how you are trying to deploy, you need Excel as well. This is
the case if you are passing an excel spreadsheet as the parameter to the
bm.exe tool.
Matt
"metin" <anonymous@discussions.microsoft.com> wrote in message
news:8C29BD23-F8DF-4E2A-93D5-D14F308747B3@microsoft.com...
> Matt,
> we have also same problem. We are not able to deploy BAM excel with m.exe.
It gives us olways "query interface error".
> under add/remove programs, there is only DTC and this one is enabled.
> We have SQL client utilities. enterprise managr and analysis manager are
working I can connect and query the databases.
>
> any ideas, thanks in advance,
> -metin
>
| |
| Kumble 2004-05-25, 4:37 pm |
| Matt
I tried all the combination you have said. But still I am getting the following error.
Failed to create Management Database "BizTalkMgmtDb" on server "machinename".
Statement(s) could not be prepared.
Invalid column name 'uidGuid'.
SQL script file: "C:\\program Files\\Microsoft BTS 2004\\Schema\\BTS_Tracking_Editor.sql"
I have installed SQL Server on WIndows Server 2003 box with Server/DB collation level set to sort order binary.
Somewhere I read that it should not be binary, it should be changed to SQL_Latin1_General_CPI_CI_AS
Is that correct? Any other way to fix this issue
I feel that MIcrosoft Documentation with this regard is poor. I am not getting any information from anywhere
Thanks in aadvance
| |
| Matt Milner 2004-05-25, 4:37 pm |
| You can create the database(s) ahead of time and leave it blank. When you
create the database in Enterprise Manager, you can set the collation for the
database.
Not sure there is a way to change the collation for the server after it is
intalled.
Matt
"Kumble" <anonymous@discussions.microsoft.com> wrote in message
news:70A857FB-0140-4698-BD5B-FD1D51B24A9C@microsoft.com...
> Matt
>
> I tried all the combination you have said. But still I am getting the
following error.
>
> Failed to create Management Database "BizTalkMgmtDb" on server
"machinename".
> Statement(s) could not be prepared.
> Invalid column name 'uidGuid'.
>
> SQL script file: "C:\\program Files\\Microsoft BTS
2004\\Schema\\BTS_Tracking_Editor.sql"
>
> I have installed SQL Server on WIndows Server 2003 box with Server/DB
collation level set to sort order binary.
> Somewhere I read that it should not be binary, it should be changed to
SQL_Latin1_General_CPI_CI_AS
>
> Is that correct? Any other way to fix this issue
>
> I feel that MIcrosoft Documentation with this regard is poor. I am not
getting any information from anywhere
>
> Thanks in aadvance
>
>
>
|
|
|
|
|