Unable to install SDM error "failed to connect to the datamart server. Please check credentials"

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

Attempting Install Service Desk got error message: "failed to connect to the datamart server. Please check credentials " at the bottom of installation the screen 

Install.log

2021/06/22 10.20.39.426 INFO  [AWT-EventQueue-0] [DatabasePersister] Unable to obtain Database Connection for user : mdbadmin May be a fresh installation.Cannot open database "mdb" requested by the login. The login failed. ClientConnectionId:
2021/06/22 10.20.39.426 ERROR [AWT-EventQueue-0] [DatabasePersister] Connection to database failed

Environment

Release : 17.1

Component : SERVICE DESK MANAGER

Cause

Issue SQL credentials are incorrect

 

Resolution

Verify that you can log into database with your credentials

If you can't log into SQL follow Create a Login to create a SQL Server login for Datamart database

use Mixed Authentication (preferred), Windows Authentication or SQL Server Authentication

verify that you can log into the database with your new credentials

Attempt to install Service Desk Manager again with your new credentials

Additional Information

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login?view=sql-server-ver15