Symantec Access Management

Expand all | Collapse all

Policy server fresh install: configuring MSSQL Server as policy store error

  • 1.  Policy server fresh install: configuring MSSQL Server as policy store error

    Posted 02-24-2017 06:14 PM
      |   view attached

    Hi,

     

    I'm installing SiteMinder Policy Server r12.5 on a Windows 2012 R2 server. I have MS SQL Server 2008 R2 installed on the machine and I'm trying to have the Policy Server Configuration Wizard automatically set up a policy store for me on MS SQL Server.

     

    So I check "Policy Store" on the "Choose Features" screen -> "Relational Databases" -> "Microsoft SQL Server (2005 or 2008)", and enter my DB information.

     

    The problem is that no matter what Database Information I type in, when I click next I get a "Test database connection failed!" Error (see attached screenshot).

     

    I'm new to SiteMinder so maybe I'm overlooking something basic. Looking for some tips. Thanks!



  • 2.  Re: Policy server fresh install: configuring MSSQL Server as policy store error

    Posted 02-24-2017 08:09 PM

    Hi , 

     

    SiteMinder Policy Server r12.5 on a Windows 2012 R2 server is not supported.

     

    Refer : 12.5 Platform Support Matrix : https://support.ca.com/phpdocs/7/5262/5262_125_PSM.pdf

     

    End of Service or Support for CA SiteMinder r12.5 is currently scheduled to be discontinued on March 31, 2017.

     

    https://www.ca.com/us/services-support/ca-support/ca-support-online/product-content/status/announcement-documents/2015/ca-siteminder-r12-5-end-of-service-announcement.html

     

    Kindly use the supported version . 

     

    Refer PSM :

     

    https://www.ca.com/us/services-support/ca-support/ca-support-online/product-content/recommended-reading/technical-document-index/ca-siteminder-informational-documentation-index.html#PSM

     

    Regards,
    Leo Joseph.



  • 3.  Re: Policy server fresh install: configuring MSSQL Server as policy store error

    Posted 02-24-2017 08:10 PM

    Policy server 12.5 is not supported on windows 2012R2.

    You can go either 12.52SP1CR2 (or later) or 12.52SP2



  • 4.  Re: Policy server fresh install: configuring MSSQL Server as policy store error

    Posted 02-28-2017 10:39 AM

    Thanks for the quick responses! I've installed the Policy Server on a Windows 2008 R2 SP1 machine, with MS SQL Server 2008 R2. Unfortunately still seeing the same issue. I've attached the database information below.



  • 5.  Re: Policy server fresh install: configuring MSSQL Server as policy store error

    Posted 02-28-2017 10:48 AM

    We see that Database Server Name is "(local)".

    Did we try using a proper IP Address OR Hostname?

     

    We see that DatabaseName is "SQL2008R2".

    Did we create a Database instance with the name as SQL2008R2? See below screenshot. The Database name has to match a database instance.

     

    Also did we try using the same connection details on a SQLEditor tool e.g. SQLDeveloper or RazorSQL - to verify the connection details and credentials work.

     

     

     

     

    Regards

    Hubert



  • 6.  Re: Policy server fresh install: configuring MSSQL Server as policy store error

    Posted 02-28-2017 01:09 PM

    Other than this I would suggest checking for firewall.

    You can do this by performing telnet to database port from PS machine.



  • 7.  Re: Policy server fresh install: configuring MSSQL Server as policy store error

    Posted 03-01-2017 03:53 PM

    I've just tried both the IP address and the hostname of the box and neither worked. I'm able to connect to the database using SQL Server Management studio.



  • 8.  Re: Policy server fresh install: configuring MSSQL Server as policy store error

    Posted 03-01-2017 04:12 PM

    your database name is ReportServer$SQL2008R2 (as per SQL Studio screenshot).

     

     

    but in config wizard we are providing only SQL2008R2

     

     

    create a new database with the name as SQL2008R2.