Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > ERROR DBConfigProcessor - Error while executing script - profile name is not valid

ERROR DBConfigProcessor - Error while executing script - profile name is not valid

Created by Juan Carlo del Rosario, last modified by MindTouch on Jun 23, 2016

Views: 1,943 Votes: 0 Revisions: 7

Overview

Configuration Wizard fails with the following error:

ERROR DBConfigProcessor - Error while executing script - profile name is not valid
An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back..
 Error details: System.Data.SqlClient.SqlException (0x80131904): profile name is not valid
An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, 

at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.ExecuteSqlBatch(IDbConnection connection, String sqlQuery, ConfigurationLogDelegate configLog)
ClientConnectionId:17b812c6-627b-4531-b07d-edbb1edd7df5
 Failing Sql command:

-- 
-- C:\Projects\NTA\NTAPepper\Src\Src\Config\SQL Scripts\Pre\AddNewFileGroupsToDB.sql
-- 
-- Add new files groups to existing database

DECLARE 
@dbName nvarchar(200), 
@dbScript nvarchar(max)

SET @dbName=db_name();

CREATE TABLE #NetFlowTableInfo
(
 TableName nvarchar(100) COLLATE database_default,
 

Environment

NPM v11.5.2 

Cause 

The Orion account being used to access the database does not have the proper permission/s.

Resolution

  1. Provide a sysadmin role to the Orion account from your SQL Management Studio.
    Note: This needs to be provided by your SQL administrator. 
  2. Re run the Configuration Wizard.

 

 

Last modified

Tags

Classifications

Public