Authentication methods to connect to MS SQL Server/Oracle Database from Advanced Authentication

Products

• CA Strong Authentication

Issue/Introduction

Advanced Authentication product is designed to support both Oracle and Microsoft SQL Server databases as backend systems. While multiple authentication mechanisms are available in these database platforms, this KB article highlights the supported Authentication Methods to connect to these databases.

Environment

Advanced Authentication

Release : 9.1.5.c

Resolution

MS SQL Server:

Advanced Authentication product currently supports only SQL Server Authentication when connecting to Microsoft SQL Server.

SQL Server Authentication requires a dedicated SQL login with a username and password that are managed within the SQL Server instance, independent of Windows accounts or Active Directory. This ensures a consistent authentication experience across different environments and simplifies database connectivity for the product.

Oracle:

Oracle Database supports multiple authentication methods to verify user identities before granting access. Advanced Authentication product currently supports the below method only.

1. Database Authentication (Password Authentication)

   • Users are authenticated using a username and password defined within the Oracle database.

   • The credentials are stored in the data dictionary and verified by the database server.

   • Most commonly used for local accounts and application connections.