Configuring Management Reporter to be used on different Domain

I usually heard that Management Reporter can only be run on domain on which it has been installed, but fortunately I came across a case where one of my client changed the domain where MR Server was installed (Server where it was first installed).

With detail investigation I came to know ' If there is will so there is a way :)' Following is the method to re-configure MR Settings in order to run MR on different domain.

1. Re-Configure Managment Reporter Service (Run > Services.msc > Change the logon as per new domain user)

2. Re-Configure Management Reporter Application Pool (IIS > Management Reporter Application Pool > Advanced Settings > Change the ID for Login as per new domain )

3. Re-Configure Management Reporter Site Security (IIS > Management Reporter Websites > Advanced Settings > Change the ID for Login as per new domain )

4. Now if you run Management Reporter, you shall see that you are unable to login to MR because you are not authorized to login (You username is not authorized to login to MR ) --> Something like that not sure

5. Run SQL Profiler

6. Re-Try to login and see the entries made by MR to SQL Profiler

7. You should see the long SID Key --> something like S-1-5-21-1024493168-1997020141-3530977040-1000

8. Key is not that difficult to find as SQL Makes 6 to 7 entries and easily visible at the end of the Query

9. Now we are required to update Management Reporter Database

8. Login to SQL Server with SA Credentials

9. Select Management Reporter Database

10. Now we are required to update tables that is : SecurityUser &  SecurityPrincipal

11. Update user name and SID Fields in Security Principal & SecurityUser as per new user of domain

12. You shall now be able to run MR

13. Goto Security are re-configure other users

I guess that would be helpful for others :)

Thanks alot

Management Reporter Installation

Before you start with Management Reporter Installation make sure you have following pre-requisites installed on you computer,

• It can only be installed on DOMAIN Connected Computer
• Setup Must be run from Domain User
• IIS 6 Metabase Compatibility Feature for IIS 7
• ASP.Net
• WCF HTTP Activation
• SQL SERVER COMPACT 3.5 SERVICE PACK 2 

Start Management Reporter installation, I follow the following method of installation and also prefer it,

Install Management Reporter Database

Install Management Reporter Server

Install Management Reporter Client

Install Management Reporter Data Provider


You need to install all the above components to Design and View reports on Management Reporter.

It is always advised to create a new Domain User for Management Reporter, and supply that user whenever Windows User is required for setup. Use SQL Authentication whenever setup asks and gives option to select between SQL/Windows Authentiation. Add Windows login of MR User to SQL Server, and provide server roles as SysAdmin and Public.

Once you done with the installation you need to login windows with MR user and add other Windows user to use the application. Open Designer to add users.

Install Latest Feature Pack, update as the way you installed that is first update Server then Client and finally the data provider.

Some Errors,

ERROR 25000 -- > SQL SERVER COMPACT 3.5 SP2 is not installed or not properly installed, make sure you install both 32 and 64 bit version of the component on 64 Bit OS.

If MR Report Queue stucks, 

• Restart Management Reporter Service > Start > Run > Services.msc > Restart Management Reporter Service
• Restart IIS > Start > Run > CMD > (TYPE) IISRESET
• Recycle Management Reporter Application pool in IIS
• Restart Management Reporter Website in IIS
• Restart Management Reporter Application Pool is IIS.