Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Configuration wizard error: Error while executing script - Invalid filegroup primary specified

Configuration wizard error: Error while executing script - Invalid filegroup primary specified

Created by Norsolihati Selamat, last modified by Kevin.Swinson on Nov 09, 2017

Views: 1,073 Votes: 0 Revisions: 6

Updated August 30th, 2016

Overview

Configuration Wizard ends with the following error:

Error while executing script - Invalid filegroup primary specified

 

Configuration wizard log will show:

ERROR DBConfigProcessor - Error while executing script - Invalid filegroup 'primary' specified..
 Error details: System.Data.SqlClient.SqlException (0x80131904): Invalid filegroup 'primary' specified.
  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

Environment

NPM version 11.5.x

Cause 

The error is due to case sensitive DB collation.

 

Resolution

Please make sure the SQL server and database collation is as follows:
The right collation should be 'SQL_Latin1_General_CP1_CI_AS' (case insensitive)

 

 

 

Last modified

Tags

Classifications

Public