Configuring MSSQL Database


NetFlow Analyzer lets you configure and use MSSQL database.

 

Product Limitations:

 

Configuring MSSQL database can take place only if the product is installed on Microsoft Windows operating system

NetFlow Analyzer does not support the following:
- Automatic deletion of oldest raw data, when free disk space goes below the user defined value
- Email alert generation, when the free disk space goes below the user defined value

 

The steps to configure and install Netflow Analyzer server with SQLSERVER as the database is given below:

  1. From the installed MS SQLSERVER, copy the files bcp.exe and bcp.rll to <NetFlow Analyzer Home>\bin folder.
  2. Invoke the <NetFlow Analyzer Home>\bin\changeDBServer.bat, to configure the MS SQLSERVER credentials like ServerName, Port, UserName and Password.
  3. Database Setup Wizard pops-up.
  4. Please check if the TCP/IP ports are turned on. In case they are not, please enable TCP/IP.
  5. tcp ip port enabling

  6. In the wizard screen, select Server Type as SQL Server. Available SQL Server Instances are listed in a combo box. Enter the Host Name and Port of the SQL Server from the instances. ( NetFlow Analyzer will work only with default instance)
  7. Select the authentication type using the "Connect Using:" options.
  8. The options are:
    1. Windows Authentication
    2. For Windows Authentication, enter the Domain Name, User Name and Password. Ensure that both NetFlow Analyzer server and SQL Server are in the same domain and logged in with the same Domain Administrator account.

       

       

    3. SQL Server Authentication
    4. For SQL Server Authentication, enter the User Name and Password.

       

       

  9. Click Test button to check whether the credentials are correct. If the test fails, the credentials may be wrong, recheck and enter the correct credentials.
  10. Click Save button to save the SQL Server configuration. Note that, it will take few minutes to configure the settings of the SQL Server database.
  11. Start the netflow Analyzer Server/Service to work with the MS SQLSERVER as the database.
Copyright © 2010, ZOHO Corp. All Rights Reserved.
ManageEngine
Copyright © 2010, ZOHO Corp. All Rights Reserved.
ManageEngine