When you configure a Dynamics SL company in Management Reporter, you receive the following error message:
An error occurred while loading the company wizard. Contact your system administrator.
This error can be cause by incorrect SQL permissions on the user running the Management Reporter services.
To use the Dynamics SL provider, the user who is running the Management Reporter services requires Execute permissions to the following stored procedures in the SL System database:
The script in this section can be used to grant the required Execute permissions to the service user.
Steps to run the script:
1. Make a SQL backup of your SL System database.
2. Replace the "DOMAIN\MRSERVICEUSER" text in the script with the user running your Management Reporter Services.
3. Run the following script against the SL System database:
DECLARE @CMD varchar(1000)
DECLARE @MRServiceUser varchar(50)
SET @MRServiceUser = 'DOMAIN\MRSEVICEUSER' --(domain\username format)
SET @CMD = 'grant exec on Company_Active to ['+ @MRServiceUser + ']
grant exec on Get_User_Info to ['+ @MRServiceUser + ']
grant exec on getAuthenticationType to ['+ @MRServiceUser + ']
grant exec on getVersion to ['+ @MRServiceUser + ']
grant exec on GetInfo to ['+ @MRServiceUser + ']
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'''+ @MRServiceUser + ''') and NOT EXISTS(SELECT * FROM sys.database_principals WHERE name = N'''+ @MRServiceUser + ''')
exec sp_grantdbaccess '''+ @MRServiceUser + ''''
4. Restart the Management Reporter Process Service and the Management Reporter Application Pool.
Please contact support if you have questions about these permissions or the script listed here.