Confirming the Metalogix Extensions Web Service Installation
While there are no settings that need to be configured for the Metalogix Extensions Web Service, there is a way to confirm that it is installed correctly and is working. Details can be found in the Content Matrix Advanced Installation Guide.
Selecting the SQL Database You Want to Connect to
The first time you launch the Content Matrix Console you will be prompted to select the SQL database that you want to connect to. For evaluation purposes, you can select Connect to New Job List (SQL Server Compact 4.0* Required), but SQL CE 4.0 must be installed on the machine. You can download it from Microsoft, install it, then restart the Console. For a production environment, it is recommended that you always use a full SQL database. Options are:
·Connect to Job Database (SQL Server)
·Connect to Distributed Database (SQL Server)*
* NOTE: Distributed Migration is not supported for File Share or Public Folder Editions, so the option Connect to Distributed Database (SQL Server) is not available. In order to use this option in SharePoint Edition, Distributed Migration must be configured. Refer to the SharePoint Edition documentation for details.
·Connect to New Job List (SQL Server Compact 4.0* required)
·Connect to Existing Job List (SQL Server Compact 4.0* required)
* NOTE: The use of SQL CE in a production environment is discouraged because of the following limitations:
§It uses a single .lst file that is less robust and reliable and may be corrupted after the database reaches 4 GB.
§Data compression is not supported.
§Support for large objects is limited.
§Microsoft support for SQL CE has ended.
If you still want to use SQL CE for evaluation purposes, SQL Server Compact 4.0 must already be installed on your machine. You can download it from Microsoft, install it, then restart the Console.
NOTE: If you have upgraded from version 9.3 or earlier and are using SQL CE (.lst) files but SQL Server Compact is not installed, a pop-up will display. You will be given the option of either installing SQL Server Compact 4.0 or selecting a different Job database.
To create or connect to a full SQL database:
IMPORTANT: If you are connecting to an Azure SQL database, the database must already have been created via Azure Portal. You cannot create or delete an Azure SQL database from within Content Matrix.
1.From the Please connect to a job database dialog, select Connect to Job Database (SQL Server).
2.Complete the Connect to SQL Server dialog:
§If you are connecting to an on premises SQL database, create (using the New Database option) or select the database you want to use.
§If you are connecting to an Azure SQL database, select the database that has been created in Azure Portal for use by Content Matrix. (Note that the New Database and Delete Database options will be disabled.)
3.If you want to use an encrypted connection to the database, check the Encrypt Connection box.
NOTE: If the certificate used for encryption is not trusted, you will also need to check the Trust Server Certificate box.
4.Select an Authentication method for connecting to SQL server:
·Use Current Windows User
OR
·Use SQL Server Login
NOTE: Currently, Use SQL Server login is the only valid option for an Azure SQL server.
5.Click [OK].
Additional Documentation
Content Matrix documentation ships with the application, but is also available online at https://https://support.quest.com/content-matrix/technical-documents.
Additional documentation is described in the Content Matrix Advanced Installation Guide.
About Us
Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT landscape. From database and systems management, to Active Directory and Microsoft 365 management, and cyber security resilience, Quest helps customers solve their next IT challenge now. Around the globe, more than 130,000 companies and 95% of the Fortune 500 count on Quest to deliver proactive management and monitoring for the next enterprise initiative, find the next solution for complex Microsoft challenges and stay ahead of the next threat. Quest Software. Where next meets now. For more information, visit www.quest.com.