Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you configure a Dynamics SL company in Microsoft Management Reporter: "An error occurred while loading the company wizard."

Error message when you configure a Dynamics SL company in Microsoft Management Reporter: "An error occurred while loading the company wizard."

View products that this article applies to.

Symptoms

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.


↑ Back to the top

Cause

This error can be cause by incorrect SQL permissions on the user running the Management Reporter services.

↑ Back to the top

Resolution

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:


Company_Active
Get_user_Info
getAuthenticationType
GetInfo
GetVersion

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 + '''' 
exec (@CMD)


4. Restart the Management Reporter Process Service and the Management Reporter Application Pool.



↑ Back to the top

More Information

Please contact support if you have questions about these permissions or the script listed here.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2569262
Revision : 1
Created on : 1/7/2017
Published on : 5/15/2012
Exists online : False
Views : 395