Hello,

From a non-development machine, I'm running a customized/compiled version of the SF Database Installer sample app and am getting the following error when the DDT metadata is deployed:

The SQLSMOMergeModulel.msm was installed on the workstation along with the SF DLL's.

Any ideas?

• 12/03/2014 2:10:53 PM -> Deploying meta-data for database 'DDTdeploymentTest'
X 12/03/2014 2:10:53 PM -> An error occurred while deploying the meta-data to the server.
X 12/03/2014 2:10:53 PM -> IndexOutOfRangeException       
X 12/03/2014 2:10:53 PM ->   Index was outside the bounds of the array.       
X 12/03/2014 2:10:53 PM ->        
X 12/03/2014 2:10:53 PM -> Source     : Microsoft.SqlServer.Smo       
X 12/03/2014 2:10:53 PM ->        
X 12/03/2014 2:10:53 PM -> Stack Trace:        
X 12/03/2014 2:10:53 PM ->        
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException(String propertyName, PropertyAccessPurpose pap)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.PropertyCollection.GetProperty(String name)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetDbComparer(Boolean inServer)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.InitializeStringComparer()       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.get_StringComparer()       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase.InitInnerCollection()       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetObjectByKey(ObjectKeyBase key)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.Contains(ObjectKeyBase key)       
X 12/03/2014 2:10:53 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.FindDatabase(Int32 DatabasePK)       
X 12/03/2014 2:10:53 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureDatabases()       
X 12/03/2014 2:10:53 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployMetaDataThread()       
X 12/03/2014 2:10:53 PM ->  

Hi William,


Be aware that for an end user, you don't need to install the SQL Management Studio, that is overkill for any installation, what you need is the SharedManagementObjects.msi as posted in my previous message.
in fact here are the link for SQL 2014 which includes the files you need:

Microsoft® SQL Server® 2014 Feature Pack

http://www.microsoft.com/en-in/download/details.aspx?id=42295

Remember you will need these 2 files for either x64 or x86

• SharedManagementObjects.msi
• SQLSysClrTypes.msi

Enjoy!!!!

Edhy Rijo

Thanks for the information Edhy!

I did run into problems installing the 2012 versions of the CLR/SMO packages on Windows v8.1 and posted it to the SQL Server forums.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c55d8104-79aa-44d1-9df1-05416a4ad7ae/sharedmanagementobjectsmsi-wont-install?forum=sqldatabaseengine

The response was the 2012 packages are not Win8.1 compatible. I ran into the same error when attempting to install the 2014 versions too.

Anyhow, the SSMS install is a good work around until the StrataFrame SQLSMOMergeModulel.msm is updated to work w/ SQL 2012.

Bill