Who is this article for?

IT Personnel performing a Ideagen Quality Management installation.

Understanding of server management and admin access is needed.

This error will cause the Ideagen Quality Management server installation to failure.

This error is not a Ideagen Quality Management error and is caused by the installation wizard is unable to reach the SQL server. In most cases this will occur if you do not have access to reach the SQL Server or if you have Expired Certificates or invalid Certificates on the SQL Database Server for the user account or the computer account. 

This article outlines steps to resolve the error:

1. Browse to the Server
2. Review User Account
3. Enable TCP/IP in SQL Configuration Manager
4. Review SQL Certificates

1. Browse to the Server

If you are typing the server name and instance of the SQL server into the installation then you should use the browse button to confirm the machine you are on can reach the SQL server. If you cannot browse to the SQL Server then the issue is the visibility / access to the server.

If you are unable to browse to the server then this suggests an issue with TLS configuration, TCP/IP configuration or your user account does not have appropriate access.

2. Review User Account

If you are performing the installation as a Windows user then you should:

• Confirm you have access to reach the SQL server.
• Confirm you can log in to the SQL Server using these credentials.
• Attempt to install using your SQL 'sa' account. 

3. Enable TCP/IP in SQL Configuration Manager

4. Review SQL Certificates

In SQL 2019 certificates are managed as part of Microsoft SQL Server. It is important that these certificates are valid. For more information on managing certificates in SQL Server please visit Microsoft Certificate Management.

Delete the unwanted/invalid Certificates on the server and then try to connect to SQL.