7.X - When installing MiCC with remote SQL, you must install...

Expand / Collapse

7.X - When installing MiCC with remote SQL, you must install local SQL with Management Studio (2012 or 2014)

Article ID: 52224 - Last Review: September 24, 2015


When installing the MiContact Center software onto a server using a remote SQL instance, you encounter an error. 


An error will be thrown that looks like the following:

Error     2014-Aug-21 14:19:29.017   Exception caught while attempting to execute task: System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException(String propertyName, PropertyAccessPurpose pap)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetDbComparer(Boolean inServer)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.InitializeStringComparer()
   at Microsoft.SqlServer.Management.Smo.AbstractCollectionBase.get_StringComparer()
   at Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase.InitInnerCollection()
   at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.InitializeChildCollection(Boolean refresh)
   at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.Refresh(Boolean refreshChildObjects)
   at prairieFyre.ConfigurationWizard.Tasks.SqlTask.SqlTask.CreateDatabase(String aScriptName)
   at prairieFyre.ConfigurationWizard.Tasks.SqlTask.SqlTask.Process()
   at prairieFyre.Configuration.TaskManagement.Task.Process()
   at prairieFyre.Configuration.TaskManagement.TaskList.processTask(Task t) 


Your local SQL instance is missing some required management objects. 


Ensure that SQL 2012 or newer is installed on the local server with an instance name of SQLEXPRESS.  Management Studio must also be installed locally before installing the MiContact Center software. 



Keywords: remote SQL install installation objects error

Rate this Article:

Add Your Comments

Name: *
Email Address:
Web Address:
Verification Code:

Last Modified:Thursday, September 24, 2015
Last Modified By: AndrewM
Type: FIX
Article not rated yet.
Article has been viewed 10,082 times.