Submit a ticketCall us
Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA - Knowledgebase Articles > NTA FlowStorage configuration on SQL Fails

NTA FlowStorage configuration on SQL Fails

Updated 20-12-2018

Overview

When running the Configuration Wizard with NTA 4.4 (or higher) it errors out when running the NetFlowTrafficAnalysisFlowStorage.DBStructure. 

 

The error on the Configuration Wizard log is:

ERROR DBStructureProcessor - Error reported during database creation An exception occurred while executing a Transact-SQL statement or batch.SQL string: CREATE DATABASE [FlowStorage] COLLATE SQL_Latin1_General_CP1_CI_AS
<SQL CREATE SCRIPT OMITTED>
Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: CREATE FILE encountered operating system error 3(The system cannot find the path specified.) while attempting to open or create the physical file '<FilePathForTransactionLog>'.

Environment

  • NTA (4.4 or higher) with FlowStorage on SQL

Cause

The SQL Server configuration is pointing to a folder that does not exist in the system.

Resolution

 There are two options to resolve this issue: create the missing folder or change the SQL default configuration to a folder that exists in the system.

 

To verify what folder is configured in the SQL Instance:

  • Open the SQL Server Management Studio
  • Connect to the Instance where the Database resides
  • Right-click the SQL Instance on the Object Explorer and select Properties
  • On the Server Properties Windows, Navigate to "Database Settings" and you will see the "Database Default Locations":

clipboard_e14af659fb6e5504b11a14d4d058c7136.png

 

Now you can either, change this location to folders that exist, or create the folders defined on defaults if they do not exist in the system.

The SQL Server will not create this folders, they need to exist in the system.

 

Once the folders are created/changed just run the Configuration Wizard again.

 

 
Last modified

Tags

This page has no custom tags.

Classifications

Public