If you can’t get into the Symantec Anti-Virus Reporting server, you may have locked out the admin account – don’t worry, this is a relatively easy thing to resolve if you have the username. If you’re working with a client, they may have no idea what the username was either – don’t fret, we can fix that too if you have the SA password. If you don’t have the SA details either then there is still hope!
You’ll need to be logged on as an Administrator on the server, then open up a command prompt and use the following commands – skip any that don’t apply to your situation. All these commands should be entered as a single line, ignore any carriage returns below.
TO RESET THE SA PASSWORD:
OSQL -Q “EXEC sp_password @new=’newpass’, @loginame=’sa’ ” -E
TO FIND OUT THE USERNAMES OF ADMIN USERS:
OSQL -U sa -P <sa-password> -Q “USE reporting SELECT user_name FROM adminuser”
TO RESET THE PASSWORD OF AN ADMIN USER TO ‘resetme123′:
OSQL -U sa -P <sa-password> -Q “USE reporting UPDATE adminuser SET password = ’6b42f8f5d4e916f55e81c97e0eeafdb1c85fe5bb’ WHERE user_name = ‘<user-name>’”
TO UNLOCK A LOCKED ACCOUNT:
OSQL -U sa -P <sa-password> -Q “USE reporting UPDATE adminuser SET locked=’off’ WHERE user_name = ‘<user-name>’”
Hopefully you’re now back into your reporting server – make sure you take steps to keep the details safe for next time! Either that or just bookmark this page… as ever, comments are welcome!