- Resolution 1
Check the Management Reporter Client install on the workstation and also check the Management Reporter Server install on the server. To check the version in Management Reporter, click Help, and then click About Management Reporter. The MR Client install needs to be the same version as the MR Server install.
Resolution 2
Check the Identity user is Internet Information Services Manager:
- In IIS 7:
- Expand the server name and then click Application Pools.
- Make a note of the user in the Identity column for the Management Reporter Application Pool.
- In IIS 6:
- Expand the server name and then expand Application Pools.
- Right-click Management Reporter and click Properties.
- Click the Identity tab and make a note of the user.
Change the Identity user's permissions in SQL.
-
Open Microsoft SQL Server Management Studio.
-
Expand the Security folder and then expand Logins.
-
Right-click the user that was listed as the Identity user and select Properties.
-
Click User Mapping and select the Management Reporter database.
-
In the Database role membership section, mark GeneralUser and public.
-
Click OK.
Resolution 3
Setup the user receiveing the connection error within MR.
- Run MR as a user that is setup as an MR administrator.
- In MR click Go and then click Security.
- Add the user who is receiving the connection error.
Note If it is not known what user(s) exist in MR you can run 'select * from SecurityUser' against the ManagementReporter database to find out.
Resolution 4
Start the Management Reporter Application Pool.
-
In IIS 7
- Expand the server name and then click Application Pools.
- Check the Status of the Management Reporter Application Pool.
- If it is not started, right-click the Management Reporter application pool and then click Start.
- In IIS 6
- Expand the server name and then expand Application Pools.
- Click Management Reporter and verify that it is started.
- If it is not started, right-click the Management Reporter application pool and then click Start.
Note Once these steps are completed and you get the same error, repeat these steps to check the Application Pool. If it is stopped, the password of the Identity account is incorrect and needs to be reset.
Resolution 5
Management Reporter will only function while connected to the domain used during the install. Even if all MR server components are on one computer, that computer still needs to be connected to the domain you were using when you installed MR.
Note This means that Management Reporter will not work when demonstration laptops are not physically connected to the domain or not connected using a VPN connection.
Resolution 6
Start the Management Reporter Web Site.
-
In IIS 7
- Expand the server name and then expand Sites.
- Right-click the Management Reporter Site, point to Manage Web Site and then click Start.
- In IIS 6
- Expand the server name and then expand Web Sites.
- Right-click the Management Reporter Site (or Default Web Site) and then click Start.
Resolution 7
Disable ASP.NET Impersonation.
Note This only applies to IIS 7.
-
In IIS 7, expand the server name and then expand Sites.
-
Click the Management Reporter Site and then double-click Authentication under the IIS category.
-
Right-click ASP.NET Impersonation and then click Disable.
Resolution 8
Give the Anonymous User permissions to the Management Reporter install folder.
-
In IIS 7
- Expand the server name and then expand Sites.
- Click the Mangement Reporter Site and then double-click Authentication under the IIS category.
- Right-click Anonymous Authentication and then click Edit.
- Make note of the user.
- In IIS 6
- Expand the server name and then expand Web Sites.
- Right-click the Management Reporter Site and then click Properties.
- Click the Directory Security tab and then click Edit.
- Make note of the anonymous user.
- In Windows Explorer on the MR Server.
- Go to the folder where MR is installed (by default this path is: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.0).
- Right-click the Application Services folder and then click Properties.
- Click the Security tab and make sure the anonymous user has at least Modify permissions.
Resolution 9
Verify the time on the client and server. Change the time that is incorrect. The time must be within five minutes of each other.
Resolution 10
Setup an exception in your Firewall program. Steps will vary depending on the Firewall program used but here are high level steps.
- Open your Firewall program.
- Allow the MR port (the default port during the install is: TCP 4712) through the Firewall.
Resolution 11
The MR Install Guide has the following information regarding the encrypt connection option:
You must configure SSL on the server and install certificates before you can use this option. For more information about encryption in Microsoft SQL Server, see the SQL Server documentation on MSDN (http://msdn.microsoft.com/en-us/library/ms189067.aspx).
You could also modify the config files to turn Encryption off (make a backup copy of the files before you modify them).
- In Windows Explorer, go to the MR install folder (the default install is: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.0)
- In the Application Service folder find the web.config file and right-click the file to open it in Notepad.
- Locate the <connectionstrings> and change the setting Encrypt= from True to False.
- Save the changes.
- In the Process Service folder find the MRProcessService.exe.config file and right-click the file to open it in Notepad.
- Locate the <connectionstrings> and change the setting Encrypt= from True to False.
- Save the changes.
Resolution 12
Remove the computer from the domain and then add it back to the domain. Warning A local administrator account will need to be used to logon to the computer one time after it is removed from the domain.
- Click Start, click Run and type: sysdm.cpl to open System Properties.
- Click Change and make a note of the Domain name.
- Click Workgroup, type a name (i.e. workgroup), click OK to accept changes and then restart the computer.
- After restarting, click Start, click Run and type: sysdm.cpl to open System Properties.
- Click Change and then click Domain.
- Enter the domain noted above, click OK to accept changes and then restart the computer.
Resolution 13
In IIS set ASP.NET to Allowed:
- In IIS 7
- Click the server name and then double-click ISAPI and CGI Restrictions under the IIS category.
- Right-click ASP.NET vX.XX and then click Allow.
- In IIS 6
- Expand the server name and then click Web Service Extensions.
- Click ASP.NET vX.XX and then click Allow.
Note Where vX.XX is a placeholder for the actual ASP.NET version. Beginning with MR V2 SP1 (2.0.1663.3) the version of ASP.NET used with MR is v4.0.30319.
Resolution 14
Install WCF HTTP Activation.
-
In Windows Server 2008, open Server Manager and then click Features.
-
Click Add Features and then expand .NET Framework.
-
Expand WCF Activation and then mark HTTP Activation.
-
Click Next and then click Install.
Resolution 15
For IIS 7.0:
Register ASP.NET.
- Click Start, point to Programs, and then click Accessories.
- Right-click Command Prompt and then click Run as administrator.
- Browse to the appropriate directory:
- 32-bit systems: %SystemRoot%\Microsoft.NET\Framework\v4.0.30319
- 64-bit systems: %SystemRoot%\Microsoft.NET\Framework64\v4.0.30319
- In the command prompt, type: aspnet_regiis.exe -iru
Note On a 64-bit system that has the 64-bit .Net v4.0.30319 Framework registered, you will need to set the Enable 32-bit Applications property to False on the Management Reporter Application Pool in IIS Manager.
For IIS 6.0:
Note IIS 6.0 does not support running both 32-bit and 64-bit modes at the same time.
Register ASP.NET:
- Click Start, point to Programs, and then click Accessories.
- Right-click Command Prompt and then click Run as administrator.
- Browse to the appropriate directory:
- 32-bit systems: %SystemRoot%\Microsoft.NET\Framework\v4.0.30319
- 64-bit systems: %SystemRoot%\Microsoft.NET\Framework64\v4.0.30319
- In the command prompt, type: aspnet_regiis.exe -iru
Click Start, point Administrative Tools, and then click Internet Information Services (IIS) Manager.
