Error while upgrading Fortress - Cannot resolve collation...

[Glebby]

Trying to upgrade Fortress (1.1.4.18402, WinXP, Sql Server 2000) to v2.0, getting error and rollback...

Error while upgrading Fortress - Cannot resolve collation conflict for column 6 in SELECT statement.

Please advise.

[jeremy_sg]

Could you please examine your 3 databases (sgvault, sgmaster, and sgdragnet) to tell us what their current collations are?

Also, it would help to see your install log, which is located in the %TEMP% directory of the user doing the installation. It's named fortress_install.log.

[Glebby]

sgvault Cyrillic_General_CI_AI
sgdragnet Cyrillic_General_CI_AI
sgmaster SQL_Latin1_General_CP1_CI_AS

I had to install Fortress 1.1.4 again after the upgrade failed, so I afraid the log file is not relevant as it has been overriden, it starts with:

===============================
Log started at 1 Aug 2009 - 19.11.15

Custom action assembly location: C:\inetpub\wwwroot\VaultService\bin\CustomActionExe.exe
Custom Action version: 1.1.4

FileVersionInfo: File: C:\inetpub\wwwroot\VaultService\bin\CustomActionExe.exe
InternalName: CustomActionExe.exe
OriginalFilename: CustomActionExe.exe
FileVersion: 1.1.4.18402
FileDescription:
Product:
ProductVersion: 1.1.4.18402
Debug: False
Patched: False
PreRelease: False
PrivateBuild: False
SpecialBuild: False
Language: Language Neutral

[jeremy_sg]

We'll have to take this offline to help you out. Please send an email to support@sourcegear.com with a link to this thread.