Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Netflow Traffic Analyzer (NTA) > Cannot connect to the NTA Flow Storage database hosted on a separate server

Cannot connect to the NTA Flow Storage database hosted on a separate server

Created by Interspire Import, last modified by Eric Bryant on Jul 17, 2017

Views: 1,397 Votes: 11 Revisions: 47

Overview

After you install the SolarWinds® NetFlow Traffic Analyzer (NTA) storage database on a separate server, you cannot connect to the NTA Flow Storage database from the server hosting the current NPM/NTA and Orion SQL database. 

When you run the main poller configuration wizard and attempt to connect to the NetFlow Storage database on the separate server, the following error appears:

Environment

  • Windows Server 2008 R2 SP3
  • Windows Server 2012 and 2012 R2
  • NTA 4.x or higher

Cause 

  • The NTA Flow Storage Database server is not properly installed.
  • The SolarWinds NetFlow Storage Service is stopped or not running. 
  • The hostname or IP address is incorrect.
  • The software and hardware firewall settings between the NTA Flow Storage database server and the Orion server are incorrect.
  • Your antivirus software is blocking the connection to the NTA Flow Storage Database server.
  • The SSL certificate is invalid.
  • The NTA Flow Storage is accessing the wrong database and needs to use the same database as NPM.
  • The version of the NTA Flow Storage Database does not match the version of the NTA Collector.

Resolution

Perform the following steps:

  1. Check the server hosting the NTA Flow Storage database. Ensure that:
    1. The server is running and connected to your network.
    2. The server responds to PING commands. 
    3. The NTA NetFlow Storage database is running.
    4. The hostname or IP address is correct.
  2. Verify that your antivirus software is not blocking your connection to the NTA Flow Storage database server. 
  3. Check the firewall hardware and software settings between your NTA Flow Storage database server and your Orion server. If required, disable the firewall until the NTA installation is completed. 

    See Port Requirements for SolarWinds products for more information. 

  4. Check for certificate errors in the FastBitServerService.log file. 

    If you have a certificate problem, an error appears in the file, as shown below:

    2015-12-11 18:52:18,765 [13] ERROR SolarWinds.Netflow.FastBit.Server.Utils.OrionCertificateValidator - Rejecting certificate:

    [Cert information]

    Because it does not match the Orion certificate:

    [Cert information]

    If the SolarWinds-Orion certificate changed, resolve the invalid certificate on the main poller. 

Resolve an invalid certificate on an existing installation

  1. Log in to the NTA Flow Storage Database server as an administrator. 
  2. Navigate to the following directory:

    c:\Program Files (x86)\SolarWinds\Orion\

  3. Copy  the SolarWinds.ConfigurationWizard.Plugin.NetFlow.dll file and save it as:

    SolarWinds.ConfigurationWizard.Plugin.NetFlow.dll.backup

  4. Delete the SolarWinds.ConfigurationWizard.Plugin.NetFlow.dll file.
  5. On the main poller, repair the SolarWinds Orion Core installation.
    1. Go to Add/Remove programs.
    2. Click SolarWinds Orion Core.
    3. Click Repair. 
    4. When completed, complete the steps in the configuration wizard. 

      The wizard completes without the original NTA error. 

  6. On the NTA Flow Storage database server, open the Microsoft Management Console (MMC) and navigate to Certificates > Local Computer > Personal. 
  7. Delete the SolarWinds-Orion certificate on the server. 
  8. Run the NTA Flow Storage database configuration wizard to sync the Orion database certificate.

    When completed, the wizard generates the correct certificate.

  9. On the main poller, restore the SolarWinds.ConfigurationWizard.Plugin.NetFlow.dll file by removing backup from the file name. 
  10. Run the configuration wizard again. 

Resolve an invalid certificate on a new installation

Warning: This procedure applies to new installations with an empty NTA Flow Storage Database. Executing this procedure on an existing installation will erase your NetFlow data.

  1. Log in to the NTA Flow Storage database server.
  2. Unistall the NTA Flow Storage database. 
  3. Log in to your NTA/NPM server.
  4. Uninstall NTA 4.0.

    See Uninstalling NTA for instructions.

  5. Run the Configuration Wizard.
  6. Delete the SolarWinds-Orion certificate on the NTA Flow Storage database and NTA/NPM servers.
    1. On the NTA Flow Storage database server, open the Microsoft Management Console (MMC).
    2. Add the Certificates Snap-In to the MMC console. 

      See the Microsoft KB article How to: View Certificates with the MMC Snap-in for instructions. 

    3. Navigate to Certificates (Local Computer) > Personal > Certificates and locate the SolarWinds-Orion certificate.
    4. Right-click the certificate and click Delete. 
    5. Repeat steps a through e on the NTA/NPM server. 
  7. On the primary poller, repair the SolarWinds Orion Core installation.
    1. Go to Add/Remove programs
    2. Click SolarWinds Orion Core.
    3. Click Repair. 
    4. Complete the steps in the configuration wizard. 
  8. Install the NTA Flow Storage database on the Flow Storage database server.
  9. Install the NTA main polling engine on the NTA/NPM server. 
  10. Ensure that the NTA server is using the NPM database on the NTA Flow Storage database server. Otherwise, the system will generate a connectivity error if you try to use a new database targeted only for NTA.

Resolve an invalid certificate on a Additional Poller

See Additional Poller with NTA Certificate Issue for instructions. 

UAC blocking connection to the remote server:

In some cases, the error displays during your NTA installation due to issues with user account control (UAC). 

To resolve this issue:  

  1. Right click the installer and select Run As Administrator.
  2. Enter the host name or IP address. 

 

Solarwinds was running evaluation and activated licenses

 

1. In some circumstances customer evaluation is expired and when activating licenses this still generates errors that the database can't connect. 

2. Run the Configuration Wizard against services, database, and website. 

 

WireShark is showing traffic on port 50592 to 17777

1. Run a capture on both the Poller and flow storage server and validate traffic which way is failing.

2. Telnet to 17777 on both the poller from fsdb and from poller to fsdb.

3. If there is an issue with the traffic flow one thing to check is that one of the servers has the Microsoft Monitoring Agent installed, if it does uninstall it.

 

 

Port 17777 Telnet fails with HostName

 

1. Run nslookup <IP>

2. Run Telnet <IP> 17777 from the primary server and Flow Storage Server.

3. Run Telnet HOSTNAME 17777 from the primary and Flow Storage

 

In certain cirmcumstances if the Hostname is using the shortname and the nslookup is missing the FQDN this could cause the connection issue when trying to open a connection to port 17777. 

 

 

Suggested tags: nta error, Flow Storage, connect, 

 

Updated 7/17/17 --EB

 

 

 
Last modified
12:56, 17 Jul 2017

Tags

Classifications

Public