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

PROBLEM

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



SYMPTOMS

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) 
 



CAUSE

Your local SQL instance is missing some required management objects. 



RESOLUTION

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. 



APPLIES TO

7.X 

Keywords: remote SQL install installation objects error



Rate this Article:
     

Add Your Comments


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

Details
Last Modified:Thursday, September 24, 2015
Last Modified By: AndrewM
Type: FIX
Article not rated yet.
Article has been viewed 9,738 times.
Options