Ensemble SQL Connection Strings


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 web.config files to store the connection information. There is a web.config file located in each of the “sub” application folders in the inetpub directory. By default, IIS installs to c:\inetpub\wwwroot, 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.
  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 Web application you want to find out more about, such as SharePoint (80), and click Properties.
  5. In the Default Web Site Properties window, click the Home Directory tab. The Local Path field in this tab shows the Web application root folder.

Update web.config files

There are four web.config files that must be updated. They are located in the following locations:

  • <web app root directory> \api
  • <web app root directory> \app
  • <web app root directory> \settings

Other Config Files To Update

In addition to the web.config files, there are also connection strings stored in config files for the Ensemble Services (which are not inside the inetpub hierarchy). There are four more files that need be updated: 

Ensemble Service Config File:

C:\Program Files (x86)\Symphony Video, Inc\Service\ensembleService.exe.config

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