Problem with using ExpressMaint with Microsoft SQL Express 2012

If you are trying to use ExpressMaint with Microsoft SQL Express 2012 or later, you will most likely run across the following error:

Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

This is easily repaired by installing the following items from the Microsoft® SQL Server® 2008 R2 SP2 Feature Pack:

  • Microsoft® System CLR Types for SQL Server® 2008 R2 (SQLSysClrTypes_x86.msi)
  • Microsoft® SQL Server® 2008 R2 Shared Management Objects (SharedManagementObjects_x86.msi)