Network Management

"Failed to grand SQL server permission to NTA Flow Storage Database Account" when running configuration wizard

Learn about granting Access Error when running the configuration wizard during NTA installation

First published date

4/23/2019 4:09 PM

Last published date

4/23/2019 4:09 PM

Overview

Database configuration failed:

  • Failed to grand SQL server permission to NTA Flow Storage Database Account <DATABASE  SERVER\DATABASE INSTANCE>. Check if the account used to configure NTA Flow Storage Database has the ability to grant access to other users

This error show during configuration wizard when installing NTA module 

Product section

Netflow Traffic Analyzer

Cause

  • The NTA Flow Storage database account requires the ALTER ANY CONNECTION permission in order to schedule and optimize the daily database maintenance task. 

Resolution

  • Using SQL Management Studio, run the following command:
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

USE master

GRANT ALTER ANY CONNECTION TO <NTADatabaseUser> [ AS <grantor> ]