[Legacy] PSIcapture Migration: SQL fails with Microsoft.SqlServer.Management.Smo.SmoApplication

Problem: 

PSIcapture encounters the following error when attempting to do a database migration to SQL Server.

[2/12/2013 2:14:06 PM - Warning - v4.5.5.1]

at Microsoft.SqlServer.Management.Smo.SmoApplication.EnumAvailableSqlServers(Boolean localOnly)
at PSIGEN.Capture.Data.Controls.SQLServerControl.LoadSQLServers(UltraComboEditor& cmbServers)
=== INNER EXCEPTION ===
Failed to retrieve data for this request.
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Urn urn)
at Microsoft.SqlServer.Management.Smo.SmoApplication.EnumAvailableSqlServers(Boolean localOnly)
=== INNER EXCEPTION ===
Could not load file or assembly 'Microsoft.SqlServer.SqlClrProvider, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
at Microsoft.SqlServer.Management.Sdk.Sfc.ObjectLoadInfoManager.LoadHierarchy()
at Microsoft.SqlServer.Management.Sdk.Sfc.ObjectLoadInfoManager.GetFirstObjectLoadInfo(Urn urn)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetServerVersion(Urn urn, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetObjectInfo(Object ci, RequestObjectInfo req)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetObjectInfo(Object connectionInfo, RequestObjectInfo requestObjectInfo)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.FixPropertyList(Object connectionInfo, Urn urn, String[] fields, RequestFieldsTypes requestFieldsType)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)


Solution: 

You will need to install the SQL Native Client that matches the target system, and also ensure that the user you are connecting to SQL with 'View all definitions"

While links to the 2012 Native client are provided below, newer versions may be necessary for later versions of PSIcapture.

The x64 2012 Native Client can be found here: 

http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409

The x32 2012 Native Client can be found here: 

http://go.microsoft.com/fwlink/?LinkID=239647&clcid=0x409