sqlsystemvariables

hi all I have some problem to connection with axapta. When start the system occurs an error and i don’t able to connect. The error is: Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name ‘SQLSYSTEMVARIABLES’. [SELECT VALUE FROM SQLSYSTEMVARIABLES WHERE PARM=‘SYSVARID’] . I was checked the value on sysvarid = 34 , i was checked other db that it works correctly and the value of the field sysvrid is the same. Anyone idea for help me Thanks in advance Andrea

Hi Andrea, I have encountered this problem in the past when I tried to move Axapta DB from one SQL Server to another. If this is your case, try the following from SQL QA - ------------------------------------------------- Use EXEC so_change_users_login ‘Auto_Fix’,’’ --------------------------------------------------- Notes: - Login ID (ex. sa, bmssa etc) of the Database This problem arises because change of Security Identification number (SID). You can read more about this from SQL BOL. Hope this helps, Harish Mohanbabu