3 Replies Latest reply on Aug 25, 2017 4:46 AM by smatt

    SQL Server Requirements

    smatt

      Hi All,

       

      I'm just reviewing the requirements for NPM and notice that the software requirements for Orion state that;

       

      "SolarWinds does not support the installation of any Orion product on the same server or using the same database server as a Microsoft SharePoint, Microsoft Exchange, or Research in Motion (RIM) Blackberry server."

       

      We plan to have a SQL cluster configured to host all our databases so this could be quite a serious blocker for us. Is there a specific reason and does it apply to even the latest versions of SQL? I'm thinking it might be collation related?

       

      Many thanks,

      M

        • Re: SQL Server Requirements
          neomatrix1217

          Take a look at this document

          NPM database server (SQL Server) requirements - SolarWinds Worldwide, LLC. Help and Support

           

          • You can set the database recovery model to Full Recovery if your Orion Database is hosted on a SQL Cluster or if you use Always On Availability. However, you must back up your database regularly and ensure that volume you store your transaction log has free space that is at least equal to or greater than the size of your Orion database. Your transaction logs will continue to grow indefinitely until a database backup is performed and the transactions committed to the database. We recommend daily database backups when you use the Full Recovery model.
            • Re: SQL Server Requirements
              smatt

              Thanks neomatrix1217,

               

              The issue is not that the Orion database doesn't support being hosted on a SQL cluster, but that it is not supported being hosted on the same database server as a SharePoint database. I'm not clear why this would be.

               

              EDIT: or was this an old recommendation i.e. you can co-host a SharePoint and Orion DB on the same DB server now?

               

              M

            • Re: SQL Server Requirements
              smatt

              UPDATE:

               

              The statement apparently referrs to installing and running Orion on the SharePoint, Exchange or Blackberry server itself as each of the products are known to make changes to the IIS configuration which are incompatible with Orion.

               

              Sharing the same SQL database server with these products should cause no issue.

               

              M