Error: Failed to initialize policy store in Policy Server with MSSQL

Products

• SITEMINDER

Issue/Introduction

 

Starting the Policy Server, this one reports an error and cannot start properly:

  [1944/4268][Thu Feb 09 2023 10:45:45.860][SmObjProvider.cpp:283][INFO][sm-Server-02840] Loading of policy store provider extension DLL: 'smobjodbcims' succeeded.
  [1944/6636][Thu Feb 09 2023 10:45:45.885][CSmDbSessionManager.cpp:550][INFO][sm-Server-04350] Using ODBC 'Policy Store' data source 'CA SiteMinder DSN'.
  [1944/4268][Thu Feb 09 2023 10:45:45.900][SmObjStore.cpp:1537][INFO][sm-Server-00060] Object store released
  [1944/4268][Thu Feb 09 2023 10:45:45.900][SmPolicyServer.cpp:867][ERROR][sm-Server-00450] Failed to initialize policy store

 

Resolution

 

Run manually the following command to initialize it (1):

• Import into the SQL Database (Query Analyzer):
  
  policy_server_installation_path/db/SQL/sm_mssql_ps.sql
  policy_server_installation_path/xps/db/SQLServer.sql
  
  
• Ensure the connection to the database can be tested successfully in the SiteMinder Management Console (smconsole);
• In a DOS command prompt:
  
  c:\> smreg -su password
  c:\> cd siteminder_home\xps\dd
  c:\> XPSDDInstall SmMaster.xdd
  c:\> XPSImport smpolicy.xml -npass
  c:\> XPSImport ampolicy.xml -npass
  c:\> XPSImport fedpolicy-12.5.xml -npass
  c:\> XPSImport default-fedobjects-config.xml -npass
  
  

Additional Information

 

(1)

    How to Configure a Microsoft SQL Server/Microsoft Azure SQL Database Policy Store