When using a local installation of Infor CRM software, you will need to set up a SQL server to host the Infor CRM database. When doing so, you must set up a SQL login for Infor CRM to use. Best practice for Infor CRM is to name this login sysdba, to match to owner of the sysdba schema in the Infor CRM database. When you create the sysdba login in SQL, it needs no special roles. Just the default Public role works fine. In fact, if you give sysdba the System Admin role, you will be unable to log in to Infor CRM.
When you actually load an Infor CRM database on the SQL server, you must “link up” the SQL server sysdba user with the sysdba user in the database. The easiest way to do this is with the SQL command:
sp_change_users_login 'Update_One', 'sysdba', 'sysdba'
This will allow Infor CRM to access the database with it connects to SQL with the sysdba SQL user. This command needs to run each time an Infor CRM database is restored to the server.
It is possible to use a different SQL account, if necessary. Just make sure to only give the Public role to that SQL user, and replace the second ‘sysdba’ in the SQL command with the SQL users you are using instead. For example, if I were using the SQL login “slx_account” as the user CRM will log in with, I would use the command:
sp_change_users_login 'Update_One', 'sysdba', 'slx_account'
