DataNow Forums

[floid]

If a user forgets his or her DataNOW password, the only way to reset the password is to first blank out the password, and then log back on to the DN client and set a new password. Until the admin tool becomes available, there is no direct way to set the password. The detailed steps are described below.

Using Windows Authentication

1. Open Query Analyzer and connect to your SQL Server.

2. Copy and paste the following two lines into Query Analyzer. Replace both instances of userlogin with the user's login name, and then execute the entire statement (press F5). Note that that is two single quotes at the end of the first line, not a double quote.

exec sc..dp_upd_pwd 'userlogin', ''
exec sc..dp_expire_pwd 'userlogin'

3. Have the user log back on to the DN client using a blank password. They will automatically be prompted to change the password. In the change password dialog, have them leave the old password blank.

Using SQL Server Authentication

1. Open Query Analyzer and connect to your SQL Server. You must be a member of the sysadmin server role to execute these statements.

2. Copy and paste the following two lines into Query Analyzer. Replace both instances of userlogin with the user's login name, and then execute the entire statement (press F5). Note that that is two single quotes in the second parameter of the first line, not a double quote.

exec sp_password null, '', 'userlogin'
exec sc..dp_expire_pwd 'userlogin'

3. Have the user log back on to the DN client using a blank password. They will automatically be prompted to change the password. In the change password dialog, have them leave the old password blank.