I restored an Axapta database from a different server to my new one and now get the following error message when I try to log on:
[Microsoft][ODBC Database Server Driver][SQL Server] Invalid object name ‘SQLSYSTEMVARIABLES’.
I understand what the problem is, however, the fixes I tried don’t seem to work.
I tried this:
exec sp_change_users_login ‘update_one’,‘bmssa’,‘bmssa’
I also tried changing the database owner.
exec sp_changedbowner ‘bmssa’
My installation is Axapta 3.0 SP3 on SQL 2000 SP3, running on 2003 Server SP1. I created the bmssa user after restoring the DB on the new server from a backup. From what I’ve read, the SIDs are different for the bmssa user on each DB, and that’s the reason for the error. But as I said, the above fixes didn’t fix the issue. Any help on this is greatly appreciated.