# User Management Issues on Upgrade from 7.5 to 7.6 **URL:** \ **Category:** Ignition\ **Created:** [August 21, 2013, 1:19pm UTC](https://forum.inductiveautomation.com/t/user-management-issues-on-upgrade-from-7-5-to-7-6/7103 "2013-08-21T13:19:20Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![mcgheeiv](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mcgheeiv](https://forum.inductiveautomation.com/u/mcgheeiv)\ **Post date:** [August 21, 2013, 1:19pm UTC](https://forum.inductiveautomation.com/t/user-management-issues-on-upgrade-from-7-5-to-7-6/7103/1 "2013-08-21T13:19:20Z")
A customer of ours is using database based authentication. Attempting to be proactive, we build the user management database tables using Ignition 7.6, then developed Ignition screens to manage the users and groups with Ignition 7.5 (their current version at the time). Recently we upgraded one of their servers to 7.6 and the authentication failed to work. We are encrypting the password using MD5. And storing the information in SQL Server 2008. All the user information is show correctly within the gateway (leading me to believe we filled in the “Manual” entries correctly). The authentication query “where” clause is identical to 7.5 and works correctly when executed in SQL or an Ignition project, but users can not authenticate anywhere (gateway, designer, or application). ---
**Author:** ![dave.fogle](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dave.fogle](https://forum.inductiveautomation.com/u/dave.fogle)\ **Post date:** [August 21, 2013, 5:26pm UTC](https://forum.inductiveautomation.com/t/user-management-issues-on-upgrade-from-7-5-to-7-6/7103/2 "2013-08-21T17:26:39Z")
Does your authentication query use the old format of MD5($password$)? If so try replacing the $password$ with a question mark (?). If that doesn't work could you send in your authentication query in an email to [support@inductiveautomation.com](mailto:support@inductiveautomation.com) so I can take a look at it?