Clarity

  • Private Community

  • 1.  SQL Server Error installing CA PPM

    Posted Jul 11, 2018 11:59 AM

    I'm installing CA PPM for the first time, version 15.4.1.  I'm planning on using SQL Server 2008 R2.  Getting an error restoring the database file,  "incorrectly formed".

    Anyone got any ideas here?  Do I need to upgrade SQL Server?



  • 2.  Re: SQL Server Error installing CA PPM
    Best Answer

    Posted Jul 11, 2018 12:10 PM

    never mind, found my answer.  Only these versions are supported:

    • Microsoft SQL Server 2016 Enterprise Edition: Service Pack 1 or higher
    • Microsoft SQL Server 2014 Enterprise Edition: Service Pack 2 or higher


  • 3.  Re: SQL Server Error installing CA PPM

    Broadcom Employee
    Posted Jul 11, 2018 12:12 PM

    Hi,

    I believe SQL Server 2008 R2 was only supported up to PPM Version 14.3. 

    Here are the supported MSSQL versions for PPM 15.4.1. 

    • Microsoft SQL Server 2016 Enterprise Edition: Service Pack 1 or higher
    • Microsoft SQL Server 2014 Enterprise Edition: Service Pack 2 or higher
    1. Any Microsoft SQL Server deployment that expands beyond 5,000 users must be approved by CA Technologies. Due to Microsoft SQL Server online transaction processing (OLTP) scale limitations with products like CA PPM, we recommend Oracle.