Database Connection Access Mode

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

When installing SQL database server for the MDB database, we can select Authentication Mode, Windows Authentication or Mixed Mode Authentication. Can we choose either?

 

 

 

Environment

Release : 17.1, 17.2

Component : SERVICE DESK MANAGER

Resolution

Service Desk Manager requires Mixed Mode Authentication to be enabled in your SQL database, and does not have the ability to authenticate with a Windows account.

When a request is created by an end user, it is passed to the domsrvr through the object layer, and then the server performs the query using a database agent. The servers are the only items with a direct connection to the database, and we are using the mdbadmin and the "servicedesk" database users to perform the tasks. Therefore, the Service Desk Manager requires mixed authentication mode.