Ensemble SQL Connection Strings

Follow

Note:  This document refers to Ensemble Video version 5.0 and greater.

When the Ensemble Video database is moved to a new SQL server or the SQL user is changed/modified, the connection strings need to be updated to reflect the new information. Ensemble uses connection files to store the SQL DB information. There is a connection.config file located in CONFIGS folder inside the inetpub\wwwroot\ensemble directory. By default, IIS installs to c:\inetpub\wwwroot\ensemble, however, many installations will have moved the location of inetpub for performance and data management reasons.

To determine where your Ensemble web application is installed, follow the steps below:

Determine the Web application root directory

  1. Click the Start menu in the Windows desktop, click Control Panel, and double-click Administrative Tools.
  2. In the Administrative Tools window, double-click Internet Information Services (IIS) Manager.
  3. In the Internet Information Services window, expand the node that corresponds to your computer, and then expand the Web Sites node.
  4. Right-click the Ensemble Web application and click Manage Website  ->  Advanced Settings.
  5. In the Properties window, click the Physical Path, which shows the Web application root folder.

 

Web App Connection File Updates

Update Connection.config file

Inside the inetpub\wwwroot\ensemble\Configs folder there is a file called connection.config.   Update this file with the new SQL information and save.   

Note: if you have UAC (User Access Control) enabled you might have to open Notepad (or whatever editor you choose) as ADMINISTRATOR to save the changes.  

Update Web.config file

Inside the inetpub\wwwroot\Ensemble folder there is a file called web.config.   Update this file with the new SQL information and save.   There are two (2) locations in the web.config where you will need to update the connection string.

Note: if you have UAC (User Access Control) enabled you might have to open Notepad (or whatever editor you choose) as ADMINISTRATOR to save the changes.  

 

Other Config Files To Update

In addition to the web.config files, there are also connection strings stored in config file for the Ensemble Service (which are not inside the inetpub hierarchy). 

 

Ensemble Service V2 Config File:

C:\Program Files (x86)\Symphony Video, Inc\ServiceV2\ ensembleVideo.ProcessingService.exe.config

Ensemble Main Config file: C:\Program Files (x86)\Symphony Video, Inc\Setup\applicationSettings.xml

0 out of 0 found this helpful