Part of the security matrix of Dynamics GP is the system password, which provides another layer of protection after users have already logged in to Dynamics GP by requiring the system password to be entered before certain system windows can be accessed.
While the use of a system password is technically optional, it is typically used, but often it used infrequently, and then typically by administrators. Consequently, the system password can be lost or forgotten as people leave or change roles.
Fortunately, there is a process available for administrators with access to SQL Server to reset the administrator password. In this recipe, we'll look at how to do just that.