IAYAA0002E IBM AD Build Client Connection failed when upgrading the project repository (using Microsoft SQL Server).

Explanation

Connection failed due to the following possible reasons:
  • Microsoft SQL Server was not found or was not accessible. A network-related or instance-specific error occurred while establishing a connection to Microsoft SQL Server.
  • The provider or driver that is specified in the connection string cannot be found. It might not be properly installed.

System action

IBM ADDI Build Client cannot connect to the Microsoft SQL Server instance when upgrading the project repository. The repository upgrade attempt is canceled.

User response

  1. Ensure that Microsoft SQL Server is up and running, and that it is configured to allow remote connections. For more information, see topic Microsoft SQL server configurations.
  2. Ensure that the Microsoft SQL Server instance name, the host number, and the port number are configured correctly in IBM® ADDI Configuration Service. To verify the values, go to IBM ADDI Configuration Service > Configure > Environments > your_environment > Servers > Relational Database Server. You can test the connection by clicking the Test Connection button on the Edit Relational Database Server page.
  3. If the Microsoft SQL Server Management Studio tool is installed on the same machine where IBM ADDI Build Client is running, you can use this tool to verify that the connection to Microsoft SQL Server can be made.
  4. Retry the repository upgrade action.