Submit a ticketCall us

AnnouncementsSystem Monitoring for Dummies

Tired of monitoring failures disrupting the system, application, and service? Learn the key monitoring concepts needed to help you create sophisticated monitoring and alerting strategies that can help you save time and money. Read the eBook.

Get your free eBook.

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


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
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>'.


  • NTA (4.4 or higher) with FlowStorage on SQL


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


 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":



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


This page has no custom tags.