I was doing some work with a custom table yesterday and at one point needed to make a change to the table layout via SQL Server Management Studio. However, when I tried, I got the below error message;
Last week I posted the start of a series of posts on how to install Management Reporter 2012; how to install Management Reporter 2012 – Server Prerequisites, how to install Management Reporter 2012 – Server Installation and how to configure Management Reporter 2012.
Todays post is the final post in the series on how to install Management Reporter and covers the client installation.
The client installer is part of the same installation package as the server installation (download available here (PartnerSource or CustomerSource login required).
I’ve just returned from the test centre with my MB2-866 Microsoft Dynamics CRM 2011 Customization & Configuration certification giving me three certs for Dynamics CRM, three for Dynamics GP and the Managing Dynamics Implementations (SureStep) cert.
I had memory problems on Thursday when I left work for the weekend (I forgot to take the USB pen drive containing my blog home with me) so couldn’t get the Management Reporter client installation blog post completed and uploaded; I’ll do that at lunchtime today.
On Monday the new version of Management Reporter was released, on Tuesday I posted the first in a series of posts on how to install Management Reporter 2012 server prerequisites and yesterday I posted the second part of the series on how to install the server software. Today I’ll cover the configuration of Management Reporter 2012.
To quickly recap, the server configuration I am using is four separate servers, all running Windows Server 2008 R2, but could easily be installed on one machine, or virtual machine, for use as a test system;
Domain Controller (DC1) running the ideal domain (a slight departure from my usual azurecurve) on
SQL Server (SQL1)
Reporting Server (RPT1)
Terminal Server (TS1)
The configuration is done using the Configuration Console which is installed as part of the server installation, so in my case it is on the Reporting Server (RPT1).
Yesterday, I posted the first in a series of posts on how to install Management Reporter 2012; how to install Management Reporter 2012 – Server Prerequisites. Today I’ll cover the server side of the installation.
The first step is to download the installation package; Microsoft Dynamics Management Reporter 2012 (PartnerSource or CustomerSource login required).
One thing to note about the installation of Management Reporter 2012 is that it has been much simplified over that of Management Reporter 2; some parts have been removed (no separate provider to install) and some has been moved to the new Configuration Console.
With the release of Management Reporter 2012 I thought it might be worth doing a series of posts on how to install this version.
The server configuration I am using is four separate servers, all running Windows Server 2008 R2, but could easily be installed on one machine, or virtual machine, for use as a test system;
- Domain Controller (DC1) running the DOMAIN.MSDynamicsERP.co.uk
- SQL Server (SQL1)
- Reporting Server (RPT1)
- Terminal Server (TS1)
All of the installation of Management Reporter server, and the server prerequisites, will be done logged into the Reporting Server (RPT1); the client and initial configuration will be done on the Terminal Server (TS1).
The prerequisites for MR 2012 are very similar to those of Management Reporter 2 which were covered hereThe prerequisites of Management Reporter 2012 differ from Management Reporter 2 in that only the .NET Framework 4 is common between the two versions. The addition that MR 2012 requires is the Microsoft Access Database Engine 2010 Redistributable to be installed.
The Google-fu is weak with this one (this one being me). I read a post ages ago on the subject of SmartList wildcards which looked like it would be really useful, but then, after I’d forgotton the details, couldn’t find it again no matter what searches I tried.
Then, a couple of days ago, Tim Cruickshank, on the Rose Business Solutions blog, posted a few tips and tricks he’d picked up at Convergence, one of which was SmartList Wildcards.