Error when connecting to datamart: "Failed to connect to the server using dmadmin user. Please check credentials"
book
Article ID: 186825
calendar_today
Updated On:
Products
CA Service Management - Service Desk ManagerServiceDesk
Issue/Introduction
Installation wizard fails when connected to DataMart. Error: "Failed to connect to the server using dmadmin user. Please check credentials"
Cause
The casm_dm database has not being created. The install_casm_dm.log shows the following error:
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:dc6aa8be-14c3-450c-b08a-4202b32cb8ad". MDBTools_0104I - Total time: 0H:0M:0S.