Correcting a lost password by resetting the system password
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.
How to do it…
To reset the system password, follow these steps:
Open Microsoft SQL Server Management Studio and connect to the SQL Server used for Dynamics GP. Enter a username and password, or use windows authentication to connect.
Because of the way that Dynamics GP maintains...
