Yes it does, thanks again! -- Julie Maillet Medavie Blue Cross --
Hi Julie, That is correct.. If 2 workstations are connecting to the same GP instance, but under a different ODBC server name, then one of the computer will fail to authenticate to GP, since the Pwd may have been set / reset from a different server name. This happens when some users setup...
Hi Julie Does this article I wrote in 2008 help https://winthropdc.wordpress.com/2008/10/01/why-does-microsoft-dynamics-gp-encrypt-passwords/ Regards David -- David Musgrave MVP, GPUG All-Star Managing Director Winthrop Development Consultants Perth, Western Australia http://www...
Great information everyone, thank you! Sounds like as long as we have the CNAME setup (which we already do), regardless of the SQL server or GP client being used, as long as the ODBC connection uses the same CNAME the GP user passwords should work. So in the case of my mirroring, if we had to...
Julie, I was going to second Ven on this topic.. by using an Alias (or CNAME) in the DNS, you can simply switch from one server to the other, and since the ODBC connection wont change, there is no need to reset the password. I've never tried the scenario described in the Microsoft paper about...
Hi Julie In addition to Dave's suggestions and the links you have in your original post, please also take a look at Ian Grieve's post about using Cnames to circumvent the password reset requirement. I had a similar requirement (lower environment) and was able to test Ian Grieve's...
@Julie Maillet GP Power Tools can recreate broken/damaged/missing SQL Logins and Database Users using its Database Validation feature. If the logins are working, but you want the reset the passwords, the SQL Login Maintenance feature will handle that for you. Both features allow for either a...
We want to investigate moving to use a high availability setup using the always on database mirroring tools in SQL. We're on GP version 18.3.1245 currently and our user IDs are created with the 'SQL Server Account' option versus the 'Directory Account'. I'm seeing most sources say that the GP...
Hi, If don't have support plan is impossible to do upgrade. -- Augusto Reyes Dynamics GP and Key2Act Specialist --