Mantis upgrade from 1.1.2 to 1.2.0a2 MSSQL(SQL 2005 Express)

[bkraul]

I have tried unsuccessfully to upgrade my mantis installation from 1.1.2 to 1.2.0a2, using MSSQL (SQL 2005 Express) . None of the approaches I tried seemed to help.Upgrade did not work at all, erroring out when trying to run the database upgrade script, with syntax errors, etc. I even tried to do a clean MSSQL install, to no avail. Even when manually editing the SQL script generated by the upgrade to comply with MSSQL and running it, my installation keeps complaining with the following:

APPLICATION WARNING #user_get_field() for NO_USER:

WARNING: Admin directory should be removed.

ERROR: The database structure appears to be out of date(config(databaseversion) is 0 and old upgrade tables do not exist). Please check that your database is running - we can not retrieve the database schema version. Config Table did not return a valid database schema version - please ask for support on the mantis-help mailing list if required.

Is there anything special schema-wise in 1.2.0a2 that I need for getting this to work? Install with mySQL database works normally, but it seems MSSQL does not. I tried looking for answers in the forums, but could find no info. Mantis 1.1.2 has been working great with MSSQL, so I don't understand what has changed so radically in 1.2.0a2 that makes it not work.

Has no one really attempted to use 1.2.0a2 with MSSQL (SQL 2005 Express)?

[vboctor]

Please report a bug in the bug tracker under category "db mssql".

[bkraul]

Done. Thanks.