Pyramid Pre-Installation Requirements

In preparation for your Pyramid installation and to ensure you are all set to go when you download the Pyramid Analytics BI Office, the following should be set up and available so that the installation goes smoothly:

  1. Pyramid Server
    • A Windows Server, preferably Windows 2008R2 64 bit and up, either virtual or  physical on which to install BI Office.
    • If the installation is made in a domain environment, the user which preforms the installation must be a domain user. In addition, it must have administrative rights on the machine that BI Office will be installed on.
    • If your Analysis Services cubes are located on a different server to Pyramid Analytics, then the Pyramid Analytics server should be set up with full Kerberos delegation authority within your Active Directory domain.
    • For the server, make sure the User Account Control (UAC) settings is set to "Never Notify" (Please note: changing this setting may require a server restart)
  2. SQL Server
    • Access to an instance of SQL Server from the server BI Office is installed on, for the storage of BI Office content.
    • Server Authentication mode should be set to "SQL Server and Windows Authentication mode"
    • Server collation should be set to "SQL_Latin1_General_CP1_CI_AS" (or any other collation, but it must be Case Insensitive)
    • A SQL user account with the dbcreator and public roles. It is good practice to create a SQL user specifically for Pyramid, the password for this user should be set to never expire.
  3. Domain
    • Access to a domain user account with reading privileges on the AD and preferably password set to never expire.
      It is good practice to set up a Pyramid identity with these rights rather than use an individual’s ID and password.
    • Active directory Users for the personnel who are to use/evaluate BI Office.
      These users also need access rights to the Analysis Services cubes you want to use.
  4. Authentication
    • Some thought as to how you intend to install Pyramid Analytics with respect to the authentication scheme you are considering. We support Basic, Windows Integrated, Forms and Federated Forms mechanisms. For a quick evaluation, Basic is the simplest to set up.
Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 6 yrs agoLast active
  • 2091Views
  • 1 Following