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.

          • 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

            Please follow the below steps to Reset password to default for the local admin user in NetFlow Analyzer / Network Configuration Manager / Firewall Aanlyzer : Download and unzip ResetPassword script and place the file named ResetPassword.bat and ...
          • Vectorwise Username and Password Creation over the build 12.5 and above

            Steps to Create a new user in VerctorWise database Steps if the HighPerf Reprting Engine is installed in the same server where the NetFlow Analyzer is installed: 1. Stop the NetFlow Analyzer service. 2. Download and extract the file named ...
          • 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 ...