O'Reilly logo

Microsoft Dynamics GP 2013 Cookbook by Mark Polino, Ian Grieve

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using a CNAME alias to prevent resetting all passwords in migrations or DR failovers

Microsoft Dynamics GP uses an ODBC connection for database access and the server name from this connection is used in the password encryption algorithm. This means if you need to migrate Dynamics GP to another server for any reason, such as a migration or SQL Server failover for disaster recovery, every single user will need their password to be reset. For implementations of Dynamics GP with a low user count this isn't too much of a burden, but I've dealt with clients who have over 250 users in Dynamics GP which makes resetting all passwords, even when using a GP macro, a chore not to be undertaken lightly.

It is possible, however, to avoid resetting all passwords ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required