SEP: Reset SEP console user account passwords

If the reporting database is a MSDE database, you can use the osql command. If the database is Microsoft SQL Server, use the SQL Server Enterprise Manager.

Before you begin:

1. You must know the sa user password. In the examples below, the password is: password, and the Reporting user password is reset to: resetme123
2. If the user account is locked, see KB document 2006021009444048 Resetting locked passwords for Reporting Server
3. This method is not supported by Symantec.

Reset the password with the osql command

If the reporting database is a MSDE database, you can use the osql command

To reset the password with the osql command. On the computer that runs the MSDE database, at a command prompt, type the following command:

osql -U sa -P password -Q "use reporting select user_name from adminuser" -o user_names.txt

where password is the password for the sa user account.

Open the user_names.txt file in a plaintext editor, such as Notepad. Find the user whose password needs to be reset. To reset the password, at a command prompt, type the following command:

osql -U sa -P password -Q "use reporting UPDATE adminuser SET password = ‘6b42f8f5d4e916f55e81c97e0eeafdb1c85fe5bb’ WHERE user_name = ‘<user name>’" 

where  <user name> is the user name.

Log on to the reporting server with the user name and a password of resetme123.
When prompted, change the password.

Reset the password in Microsoft SQL Server Enterprise Manager

If you use Microsoft SQL Server for the reporting database, you can reset user passwords in Microsoft SQL Server Enterprise Manager.

To reset the password in Microsoft SQL Server Enterprise Manager. In Microsoft SQL Server Enterprise Manager,

1. Expand the server that runs Reporting Server.
2. Expand Databases.
3. Expand Reporting.
4. Click Tables.
5. In the right pane, right click on the adminuser table, click Open Table and then
6. click Return all rows.
7. Find the user in the user_name table whose password needs to be reset.
8. Replace the existing string in the password table with 6b42f8f5d4e916f55e81c97e0eeafdb1c85fe5bb
9. Close the adminuser table
10.   Log on to the reporting server with the name and password of resetme123.
11. When prompted, change the password.

.