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 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 ...
                    • Migration step for NetFlow Analyzer from the build 9860 and above with Mysql database (Windows)

                      Please follow the below steps again to migrate NetFlow Analyzer build 9860 from 32 bit to 64 bit and check on the issue: STEPS: 1. Shut down NetFlow Analyzer service. 2. Backup the below directories \ files to a safe location. Note that these are 2 ...