When restoring a SalesLogix SQL database backup from one server to another, you must synchronize the database’s sysdba user to the new SQL server’s sysdba user. This can be done using a SQL stored procedure. SalesLogix provides this procedure under their database folder on the install DVD.
Inevitably I find I need this T-SQL script and spend time trying to find it. I thought putting it on my blog would be a good reference location.
sp_change_users_login ‘Update_One’, ‘sysdba’, ‘sysdba’