Error 450 when installing on existing DB's

[InsomniacGeek]

Greetings.

Fortress v1.1.4, SQL Server Express 2008.

I have moved my database files to a new server and attached them to the new SQL Server instance. Starting the setup and told it to keep the existing databases. I get this error:

Upgrade failed. The sgvault and sgdragnet databases must have the same SQL Collation. This must be fixed before upgrading the databases to Fortress.
SQL Collations must be the same for the sgvault and sgdragnet databases
Fortress Setup is exiting due to a failure or cancellation. Error Code = 450

However, looking at the databases, they all have the same collation: SQL_Latin1_General_CP1_CI_AS.
What's going on?



/Magnus

[lbauer]

That's strange. There was a bug in previous versions of Fortress that caused the upgrade to fail if collations were different. That was fixed. Of course you are reporting that your collations are the same.

What is the database collation for the Master and Temp databases in your SQL Server?

[lbauer]

It's possible that the account the installer is running under doesn't have permission to access the properties of the database to detect the collation.

1) Are you logged into the new Fortress Server machine as a domain Admin or a user with rights to modify the database?

2) These are the queries the istaller runs to determine the collation. Try running these yourself:

SELECT DATABASEPROPERTYEX ('sgvault','Collation')
SELECT DATABASEPROPERTYEX ('sgdragnet','Collation')

What are the results?