Installation fails on SQL Change Scripts step /...

Expand / Collapse
 

Installation fails on SQL Change Scripts step / MCCConnectionString registry key missing


Article ID: 52367 - Last Review: November 2, 2015

PROBLEM

When installing MiCC Version 7.1.3.1, the Configuration Wizard stops at SQL Change Scripts.  The HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\prairieFyre Software Inc\CCM\Enterprise\MCCConnectionString registry entry is not present.

NOTE: Other errors can occur as a result of this registry key being absent, including errors in the MassTransitRuntimeService, or CCMWa.  This can also cause issues with IVR callbacks.



SYMPTOMS

  • You are using Remote SQL
  • You are not licensed for Multimedia Contact Center


The error produced by the cumulative update installer will look like the following:

Info      2015-Oct-27 17:25:19.354   prairieFyre.ConfigurationWizard.Tasks.SqlTask.SqlChangeScriptTask    Running Change Scripts
Verbose   2015-Oct-27 17:25:19.369   GetCurrentSchemaVersion. Opening connection to Data Source=10.10.10.10\sqlexpress;Initial Catalog=CCMData;Persist Security Info=False;User ID=sa;Password=Password1;Connect Timeout=30;Application Name=ConfigurationWizard         
Info      2015-Oct-27 17:25:20.202   Connection String: "Persist Security Info=false;User ID=sa;Password=Password1;Data Source=10.10.10.10\sqlexpress;Initial Catalog=CCMData;Connect Timeout=30;" exists in the registry. Connection have to be checked.   
Info      2015-Oct-27 17:25:20.202   Since both: MCC Connection String and Connection String are empty or does not fit, starting to search for available local SQL instances.    
Error     2015-Oct-27 17:25:35.648   Exception caught while attempting to execute task: System.ArgumentException: There is no valid local instance of SQL Server. Please download and install SQL Server from this link and hit retry:
http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx
   at prairieFyre.ConfigurationWizard.Tasks.SqlTask.ExecuteSql.RunChangeScripts(String aPath, String aFirstScript, Boolean includeBackup)
   at prairieFyre.ConfigurationWizard.Tasks.SqlTask.SqlChangeScriptTask.Process()
   at prairieFyre.Configuration.TaskManagement.Task.Process()
   at prairieFyre.Configuration.TaskManagement.TaskList.processTask(Task t)
    



CAUSE

During the 7.X installation, the MCCConnectionString registry entry was not created. 



RESOLUTION

1. Open regedit.exe
2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\prairieFyre Software Inc\CCM\Enterprise\
3. Add a String and name it MCCConnectionString
4. Edit MCCConnectionString and ensure the value is Persist Security Info=false;Integrated Security=SSPI;Data Source=.\SQLEXPRESS;Initial Catalog=master;Connect Timeout=30;
5. Close regedit.exe.
6. You can now re-run the configuration wizard or installer.



APPLIES TO

MiCC 7.X.X.X

Keywords: Local SQL MCCCOnnectionString config wizard upgrade update error



Rate this Article:
     

Attachments



Add Your Comments


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

Details
Last Modified:Monday, November 02, 2015
Last Modified By: AndrewM
Type: FIX
Rated 5 stars based on 1 vote
Article has been viewed 12,784 times.
Options