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

Microsoft Dynamics GPAfter 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 where you pick the collation. Dealing with Microsoft Dynamics GP so much means I need to be careful with server and database collations as GP, once installed, cannot have it’s database collation changed.

We typically install SQL Server for Microsoft Dynamics GP using the SQL_Latin1_CP1_CI_AS (case insensitive, accent sensitive), which is very easy in SQL 2008 R2 Continue reading “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

Microsoft Dynamics GPI’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;

You

Continue reading “Error: Attempting To Log In From A Data Source Using A Trusted Connection”

Microsoft Dynamics GP 9 SP3 Upgrade Path To 2010 R2

Microsoft Dynamics GPI did a bit of searching and couldn’t find a specific declaration of the upgrade path from Microsoft Dynamics GP 9 SP3 to Microsoft Dynamics GP 2010 R2.

After reading around and trying to work out the correct path, I decided the likely upgrade path would be GP 9 SP3 > GP 10 SP5 > GP 2010 R2, but I would try GP 9 SP3 > GP 2010 R2 and see if it would work (although I was extremely skeptical) as this would save some time on the upgrades if it was possible. Continue reading “Microsoft Dynamics GP 9 SP3 Upgrade Path To 2010 R2”

Changing The eConnect Password In Microsoft Dynamics GP 2010

Microsoft Dynamics GPIn this post I discussed changing the password in eConnect 10. However, changes were made to eConnect 11 which means the password is not changed in the same way when using Microsoft Dynamics GP 2010.

eConnect 10 is a COM+ application while eConnect 11 is a Windows Communication Foundation (WCF) service-oriented application. This means the password change is a different process although it must still be done in two places. Continue reading “Changing The eConnect Password In Microsoft Dynamics GP 2010”

Changing The eConnect Password In Microsoft Dynamics GP 10

Microsoft Dynamics GPWhen we install Microsoft Dynamics eConnect 10 we also do so using a specially created Windows Domain user, DynamicsGPUser, which has the password policy disabled so the password never changes.

It turns out that despite this user only being used by the eConnect service, some client’s still prefer to change the password occasionally. Changing the password is a relatively simple thing to do, so long as you’re aware that the password is stored in two places. Continue reading “Changing The eConnect Password In Microsoft Dynamics GP 10”

Missing Data Source When Installing Microsoft Dynamics GP 2010

Microsoft Dynamics GPI have recently been upgrading an existing client to Microsoft Dynamics GP 2010 R2 from GP 10 SP1 on their test system. As they have lagged somewhat on versions I needed to upgrade them to GP 10 SP5 before then upgrading them to GP 2010 R2.

The databases were also being moved from a server running Microsoft SQL Server 2000 to one running SQL Server 2008; I would have preferred to move them to SQL Server 2008 R2 but due to some other business critical software to be installed on the same server, it needed to be SQL Server 2008 R1. Continue reading “Missing Data Source When Installing Microsoft Dynamics GP 2010”

Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue

Microsoft Dynamics GPIt’s always the small things which catch you out.

The recent test upgrade for a client I did between Microsoft Dynamics GP 10 SP5 and Microsoft Dynamics GP 2010 R2 hit a minor snag during the GP Utilities section of the upgrade which resulted in this error message;

Microsoft Dynamics GP 10 Utilities

Continue reading “Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue”

ODBC For Microsoft Dynamics GP on Windows Server 2008 R2

Microsoft Dynamics GPWhen installing Microsoft Dynamics GP on an x64 OS such as Windows Server 2008 R2 the Data Sources (ODBC) in Control Panel cannot be used as this will create an x64 data source whereas Microsoft Dynamics GP will only work with an x86 data source.

An x86 ODBC connection can be created by using the Data Sources (ODBC) which is located in %windir%\syswow64\odbcad32.exe. You can navigate to it using Windows Explorer or by using the Windows Run command;

Create an x86 ODBC On Windows 2008 R2

How To Remove The CEIP Reminder

Microsoft Dynamics GPWhen you install Microsoft Dynamics GP it automatically creates a recurring reminder for the Microsoft Customer Experience Improvement Program. In most cases this reminder is not wanted but removing it through the system for every user can be a bit time consuming;

For each user, log into Microsoft Dynamics GP and open the Reminders window (Microsoft Dynamics GP menu » Reminders) and open the CEIP task. In the window click Name and select an option. Flag the task as Completed and move onto the next user and repeat.

However, help is at hand in with two short SQL scripts. Continue reading “How To Remove The CEIP Reminder”