Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Install Perfion database

The Perfion database requires a running SQL Server before you can install it. Follow these steps to install a Perfion database.

Download installation file

  1. Download the most recent Database Installer from the Perfion knowledge base - Perfion Database Installer - Latest Version - Perfion Knowledge Base - Perfion Knowledge Base (atlassian.net)

  2. Extract all files from the zip-file and place them in a dedicated folder (e.g., c:\Perfion\Database)

  3. Run Perfion.DBInstaller.exe for a wizard guided installation or Perfion.DBInstaller.CommandLine.exe /help to install via a commandline/script

Install the Perfion database

Run the Perfion database installer setup package and choose ‘Install new database'

Connection

On the connection page, you setup the Microsoft SQL Server instance on which you want to install the new Perfion database and Windows Authentication or SQL Server Authentication depending on your setup. The user must be able to install a database on the specified SQL server.

Enter the name you want to use for the new Perfion database and click Next.

Database properties

On the database properties page, you can specify additional details about collation name, recovery model and the location of the SQL Server data- and log files for the database. In a standard setup all options can be left unchanged.

NOTE: Perfion requires a case insensitive (CI) collation. If your server default is case sensitive (CS) you have to choose a specific case insensitive collation name in this dialog (e.g Latin1_General_CI_AI)

Demo data

On the next dialog, you can choose if you want to install demo data. Click Next when you have made your selection.

Scheduled tasks

On the next dialog, you can choose whether or not to enable scheduled tasks for automatically updating the system license and database statistics and index maintenance. The scheduled tasks are created within the Perfion Scheduler and may be updated after installation. Default Values are once per week. On large installations or if running lot’s of import we recommend the schedule runs once per day.

Summary

The summary dialog now appears with a summary of the chosen installation options. If you are satisfied with the chosen installation options check I am sure I want to setup the new database option and click Next. This will start the actual installation.

You have now successfully installed the Perfion Database. Click Finish on the closing screen.

Create SQL Login and -User

As a best practice, you should create a separate SQL login that is restricted to the individual Perfion databases.

Create SQL Login

First create a SQL login (the username/password)

USE [Master]
CREATE LOGIN [perfion-dbuser] WITH PASSWORD = '<strong password>'
CREATE USER [perfion-dbuser] FROM LOGIN [perfion-dbuser]

Create SQL user

Once the SQL Login is created, a SQL user account can be created within the Perfion database and the account can be granted access.

Perfion currently require the database user to have Database Owner rights.

USE [<perfion database>]
CREATE USER [perfion-dbuser] FROM LOGIN [perfion-dbuser]

EXEC sp_addrolemember 'db_owner', 'perfion-dbuser'

  • No labels