BizTalk Server Setup - Error Installing BizTalk Server 2004 on Windows XP SP1

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Setup > November 2004 > Error Installing BizTalk Server 2004 on Windows XP SP1





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 Error Installing BizTalk Server 2004 on Windows XP SP1
DaveM

2004-11-09, 5:49 pm

Hello,

I'm getting the following message in the log when I attempt to
install/configure BizTalk Server 2004:

4:34:16 PM Error BtsCfg] Failed to create Management database
"BizTalkMgmtDb" on server "DAVEMXP".
Statement(s) could not be prepared.
Invalid column name 'uidGuid'.

SQL script file: "C:\Program Files\Microsoft BizTalk Server
2004\Schema\\BTS_Tracking_Editor.sql"
SQL command batch: "CREATE PROCEDURE [dbo].[trk_GetServiceID]
(
@ModuleName nvarchar(256),
@Servi..."
[4:34:16 PM Error BtsCfg]
d:\depot4000qfe\voyqfe\source\private\mo
zart\source\setup\btscfg\btscfg.cpp(762): FAILED hr = c0c02524


Any thoughts on what could be causing this? I've check forums, install
guides, KB and have not seen anything that leads me to an answer. Thanks in
advance.

PBR

2004-11-10, 2:47 am

Hello,

By any chance do you have your SQL Server set to use a case-sensitive
collation? BTS 2004 does not support case-sensitive collations.

-- PBR

"DaveM" <DaveM@discussions.microsoft.com> wrote in message
news:7842326F-45B2-4645-90BF-41CBC3045EBA@microsoft.com...
> Hello,
>
> I'm getting the following message in the log when I attempt to
> install/configure BizTalk Server 2004:
>
> 4:34:16 PM Error BtsCfg] Failed to create Management database
> "BizTalkMgmtDb" on server "DAVEMXP".
> Statement(s) could not be prepared.
> Invalid column name 'uidGuid'.
>
> SQL script file: "C:\Program Files\Microsoft BizTalk Server
> 2004\Schema\\BTS_Tracking_Editor.sql"
> SQL command batch: "CREATE PROCEDURE [dbo].[trk_GetServiceID]
> (
> @ModuleName nvarchar(256),
> @Servi..."
> [4:34:16 PM Error BtsCfg]
>

d:\depot4000qfe\voyqfe\source\private\mo
zart\source\setup\btscfg\btscfg.cpp(
762): FAILED hr = c0c02524
>
>
> Any thoughts on what could be causing this? I've check forums, install
> guides, KB and have not seen anything that leads me to an answer. Thanks

in
> advance.
>



DaveM

2004-11-10, 5:48 pm

Collation was the problem. Thank you!

"PBR" wrote:

> Hello,
>
> By any chance do you have your SQL Server set to use a case-sensitive
> collation? BTS 2004 does not support case-sensitive collations.
>
> -- PBR
>
> "DaveM" <DaveM@discussions.microsoft.com> wrote in message
> news:7842326F-45B2-4645-90BF-41CBC3045EBA@microsoft.com...
> d:\depot4000qfe\voyqfe\source\private\mo
zart\source\setup\btscfg\btscfg.cpp(
> 762): FAILED hr = c0c02524
> in
>
>
>

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com