Sysdba fix script for SalesLogix database restores

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’ 

ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

1 Comment

  1. Yes, I even restarted the SQLServer service just in case, still no go…

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!