Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

Home > Success Center > Network Performance Monitor (NPM) > 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,028 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