Change Auditor install fails when creating database in Azure SQL as a Service
Error message is similar to below:
[Error ODBC error: State: 28000: Error: 18456 Message:'[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user '##MS_InstanceCertificate##'.'.
Change Auditor versions 7.1.1 and later supports using an Azure managed hosted SQL instance.
Change Auditor versions prior to 7.1.1 do not support hosting the CA database on a managed hosted instance (Azure SQL for example). The following is provided as informational and on a best effort basis. Quest Support cannot assist with warning, errors, or issues encountered using Microsoft's tools to export and import the Change Auditor database. If you need to use Azure managed SQL it is highly recommended to upgrade to 7.1.1 to ensure you are fully supported:
An existing Change Auditor database must be imported to Azure for the coordinator to connect to install.
Install the coordinator as directed and point to an on-prem instance of SQL to allow the database to be created there. Then, export the database into a BACPAC format, then import into Azure.
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql
STATUS:
Official Support for Managed SQL Instances (PaaS) is currently provided in versions 7.1.1 and later.
Please take care that Azure SQL DB(PaaS) is not supported by Change Auditor.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center