Submit a ticketCall us
Home > Success Center > Network Performance Monitor (NPM) > Could not load file or assembly Microsoft.SqlServer.Smo version

Could not load file or assembly Microsoft.SqlServer.Smo version

Created by Dennis Harnett, last modified by Jonathon.Privett on Feb 06, 2018

Views: 2,436 Votes: 0 Revisions: 12

Overview

The following error appears when configuring the database while running the NPM Configuration Wizard:

Could not load file or assembly 'Microsoft.SqlServer.Smo version xxxxxxx'

-------------------------------

Another/Full possible error:

ERROR SceneContainer - SceneContainer:bntNext_Click: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
at SolarWinds.ConfigurationWizard.Host.Presentation.DatabaseConfiguration.DatabaseServerScene.DoValidateConfig(Boolean silentMode)

Environment

NPM 10.4.1

Cause 

This occurs when there are missing components because the SQL Management Object version is incorrect.

----------------------------------------------

Problem: (Sql server 2012) This issue happens when assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0 not found by visual studio.

Resolution

Install the required SQL Shared Management Object version. Refer to Installing SMO.

And wait for polling results.

OR

If you are on sql server 2012:

Go to http://www.microsoft.com/en-us/download/details.aspx?id=35580 and download:

  • ENU\x64\SharedManagementObjects.msi for X64 OS or
  • ENU\x86\SharedManagementObjects.msi for X86 OS,

Once installed run configuration wizard and verify it completes successfully.

 

Last modified

Tags

Classifications

Public