Specifying a new location for the xcAdmin database (4277393)

After moving the xcAdmin database to a new SQL server instance, the ControlPoint application does not load.

The connection string used to identify the SQL server instance where the ControlPoint service database (xcAdmin) is located is incorrect.

1. Open the ControlPoint Configuration Site (e.g. http://server:1818).
2. Select the ControlPoint Settings list and expand the Miscellaneous and Custom category.

   

3. Edit the xcAdminConnectionString parameter so the data source reflects the new SQL server instance:

   

The ControlPoint service account needs specific permissions to the SQL server instance to allow the Full Discovery process to run smoothly, as well as for functionality of a number of our reports. To ensure the appropriate permissions are assigned, perform the rest of the steps below:

4. Navigate to the C:\Program Files\Metalogix\ControlPoint\ControlPointFeatures folder, open xcClient.exe.config using any text editor (e.g. Notepad) and update the line below to reflect the new SQL server instance:

   

   <add name="xcAdminConnectionString" connectionString="Data Source=dos.ml.com;Initial Catalog=xcAdmin;Persist Security Info=True;Integrated Security=True;" providerName="System.Data.SqlClient" />
   

5. Run the License Manager with an account that meets the ControlPoint installation account requirements, specifically sysadmin on the new SQL server instance, and select the "Added SharePoint Web Application or Content Database" option, then click Grant Access.