Admin Password Reset for NetFlow Analzer with database MSSQL till build 11001

Admin Password Reset for NetFlow Analzer with database MSSQL till build 11001


1. Open the Management Studio on the MSSQL server
2. Select the netFlow database. Right click on netflow database and click on New Query
3. Execute the following query

update AaaPassword set PASSWORD='Ok6/FqR5WtJY5UCLrnvjQQ==', SALT='12345678' from AaaLogin,AaaAccount,AaaAccPassword where AaaLogin.LOGIN_ID = AaaAccount.LOGIN_ID and AaaAccount.ACCOUNT_ID = AaaAccPassword.ACCOUNT_ID and AaaPassword.PASSWORD_ID = AaaAccPassword.PASSWORD_ID and AaaLogin.NAME = 'admin';


4. The above query will reset the user name and password to "admin"

When you change the password again make sure that, the password should be of minimum 6 characters and maximum of 10 characters with out any special character in it.


        New to ADManager Plus?

          New to ADSelfService Plus?

            • Related Articles

            • NFA Password reset for pgsql database till version 11001

              Kindly follow steps as given below to reset the password. Note : Make sure that NetFlow Analyzer Service is running before following the below steps 1. Open a command prompt 2. Go to the <NETFLOW_HOME>\pgsql\bin directory 3. Type For Windows    :   ...
            • NFA Password Reset steps for Mysql database till version 10250

              Kindly follow steps as given below to reset the password. Please note that the NetFlow Analyzer Server is running before doing the below steps. 1. Open a command prompt 2. Go to the <NETFLOW_HOME>\mysql\bin directory 3. Type For Windows    :   mysql ...
            • NFA and NCM 12 Default Admin password Reset_postgres Database

              Forgot Password: The Forgot Password option in the login page can be used to reset the password. Make sure the Mail Server Settings and User's email ID are configured. The auto generated password will be sent to the email ID entered as the User's ...
            • MSSQL Database shrink.

              To reduce the MSSQL database size, please follow the below steps. 1. Stop the NetFlow Analyzer service. 2.Open a command prompt as administrator(Right click and run as administrator) Navigate to <NetFlow_Home\troubleshooting\>. 3. Execute the ...
            • MSSQL Server migration

              1. Stop the NetFlow Analyzer service.  2. Backup the old Netflow DB and restore on to the new DB server (Connect MSSQL client using SQL Server Management Studio and backup netflow database and restore it new server). 3. From the New MSSQL SERVER, ...