SQLSYTEMVARIABLES error - can't fix


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.


Hi, this is clipped from the BOL:


`##### Examples

This example allows the SQL Server login Victoria, which is not a user in the current database, to use the current database and alias Victoria to an existing user (Albert) in the current database.

EXEC sp_addalias 'Victoria', 'Albert'