In order to restore and access a [email protected] or [email protected] database there are a number of steps which need to be undertaken depending on the version of the software under which the database has been backed up.
For all versions of [email protected] and [email protected] (eXpense) prior to version 3.0 (i.e. 2.3, 2.4 and 2.5) it is not possible to restore a database under a different version of the software. The version under which the database is restored must exactly match the version from which the database was taken.
Irrespective of what version is being restored, if the Database is being restored from a different instance of SQL Server (for example it was backed up on a Clients SQL Server and Restored on a Support Desk SQL Server) then the following Script must be run against the database after it has been restored (in order to reset the SQL DB Owner):
sp_change_users_login ‘update_one’, ‘TWAdmin’, ‘TWAdmin’