How to reset a password if e-mail is not yet configured. NetBackup Self Service (NSS).

Description

How to reset a password if e-mail is not yet configured. NetBackup Self Service (NSS).

1. Click the 'Forgotten Password' hyperlink on the Self Service log in page.  This will generate a new password which will be written to a table (dbo.emails) in the NSS database.

2. Launch the SQL Server Studio Manager on the SQL host where the NSS databases reside.

3. Click on 'File -> New -> Query with Current Connection'.

4. In the right hand pane, paste in the following query, where 'your_database_name' is the actual name of your NSS database.

select top 1 right(Body , 56)
FROM [<your_database_name>].[dbo].[EMAILS]
Where Body like '%new password%' or Subject like '%new password%'
order by EmailID desc

So, for example, if your database name is "NetBackupSelfService", the query would be:

select top 1 right(Body , 56)
FROM [NetBackupSelfService].[dbo].[EMAILS]
Where Body like '%new password%' or Subject like '%new password%'
order by EmailID desc

5. Click on 'Query -> Execute'.

6. That query should return something like:

</p><p>BGUOTrmgx6</p></span></p></body></html>

7. The new password is returned between the <p> and </p> brackets.  In the above example, the new password is:

BGUOTrmgx6

8. Return to the Self Service log in page and enter the new password obtained via step 6.