Windows Authentication for PolicyStore/SessionStore

Products

• CA Single Sign On Secure Proxy Server (SiteMinder)
• CA Single Sign On Agents (SiteMinder)
• CA Single Sign On Federation (SiteMinder)
• CA Single Sign On SOA Security Manager (SiteMinder)
• SITEMINDER

Issue/Introduction

 

We're running a Policy Server and we'd like to know if the Policy
Server can connect to the OSBC MSSQL Policy and Session Store using
Windows Authentication ?

 

Environment

 

Policy Server 12.8SP4 on RedHat 7;

 

Resolution

 

At first glance, as stated by documentation, indeed, Policy Server
doesn't support authentication to ODBC MSSQL Server using Windows
Authentication.

  SQL Server Authentication Mode Considerations

    SiteMinder data sources do not support Windows
    authentication. Configure the data source with the credentials of a
    user that is stored in the database.

  https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/siteminder/12-8/installing/install-a-policy-server/configure-odbc-databases-as-policy-session-key-and-audit-stores/configure-an-odbc-database-as-a-policy-store/how-to-configure-a-sql-server-policy-store.html#concept.dita_97d4bf5706f139af11db4c4c127587b6bc368477_ConfigureaSQLServerDataSourceforstmndrSQLDataSource

As such, you have to configure a User and its password to connect to
an ODBC MSSQL Policy and/or Session Store.