Windows Authentication for PolicyStore/SessionStore
search cancel

Windows Authentication for PolicyStore/SessionStore


Article ID: 200443


Updated On:


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



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 ?




Policy Server 12.8SP4 on RedHat 7;




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

  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.

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