Hi,
I am trying to use the latest SMO from SQL Server 2014 to target SQL Server 2012 for getting the list of database instances.
Here is the exception I got:
Additional information: Could not load file or assembly 'Microsoft.SqlServer.SqlWmiManagement, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
Had tried with SQL Server 2012 SMO, it worked perfectly fine, but not when use SQL Server 2014 SMO.
I binged around and it seems like it is depending on sqlmgmproviderxpsp2up.mof which is available on each shared folder version respectfully, i.e. for 2012 -> C:\Program Files (x86)\Microsoft SQL Server\110\Shared and for 2014 -> C:\Program Files (x86)\Microsoft SQL Server\120\Shared.
What options should I tried to get it working?