How To Create A Domain Controller

The release of Management Reporter brought several advantages over FRx; x64 compatibility, replacement of the Access database with SQL Server and a modern client among them. However, one of the downsides is that Management Reporter requires a domain to be available for both the installation and running. Where FRx could… Read more“How To Create A Domain Controller”

Error Code 2337 When Installing Microsoft SQL Server Into A Virtual Machine

I have installed SQL Server into Virtual Machines many times in the past but I’ve recently seen an error when trying to do it again; I had a think about the error and realised that I usually installed SQL from the VM HDD and not, as I was in this… Read more“Error Code 2337 When Installing Microsoft SQL Server Into A Virtual Machine”

Transferring GP To A New Server Without Resetting All Passwords

[One of the annoyances when migrating a client’s installation of Microsoft Dynamics GP to a new server is that, unless the new server has the same name as the old one, the password of every user needs to be reset as the server name is encrypted in with the password…. Read more“Transferring GP To A New Server Without Resetting All Passwords”

How To Change The SQL Server Backup Folder

When you install Microsoft SQL Server you select the Data, Logs and Backup folder during the installation process. If you subsequently need to change these folders you can only change two of them through the SQL Server Management Studio UI. On the Server Properties dialog there are boxes for the… Read more“How To Change The SQL Server Backup Folder”

VAT 100 Is Missing

I ran into an issue recently when installing Microsoft Dynamics GP 2010 R2 where the VAT Return was not available. I was configuring the system in preparation for training a new client and was running through the Company options (Microsoft Dynamics GP menu » Tools » Routines » Company »… Read more“VAT 100 Is Missing”

Word Template Generator, Where Art Thou?

I’m currently doing some work for a client where we’re modifying some of the reports in Microsoft Dynamics GP and I’m trying to avoid using Report Writer as a) I don’t like it, b) Word template reports look better and c) I don’t want to spend time training a client… Read more“Word Template Generator, Where Art Thou?”

Missing Font Causes Crash In Management Reporter

I’ve recently been doing some work for a client where we’ve upgraded them from Microsoft Dynamics GP 10 to 2010 R2. Alongside this, we also migrated them from FRx to Management Reporter. All looked fine after the upgrade until I opened one of the rows for editing and got the… Read more“Missing Font Causes Crash In Management Reporter”

Selecting The Correct Microsoft SQL Server 2000 Collation For Microsoft Dynamics GP

After initial acclimatisation pains with Microsoft SQL Server 2008 R2 (I largely skipped 2005 and 2008 RTM) I have become used to Management Studio and do now prefer it to Enterprise Manager and Query Analyser. One of the things I really like about SQL 2008 R2 is the installation process… Read more“Selecting The Correct Microsoft SQL Server 2000 Collation For Microsoft Dynamics GP”

Error: Attempting To Log In From A Data Source Using A Trusted Connection

I’ve been building a test environment in a virtual machine the last few days to do a migration from Microsoft Dynamics GP 9 SP3 to 2010 R2. After completing the upgrade I tried to log into GP and received the following error;