Saturday, 25 June 2011

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
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.

1 comment: