Step by Step the creation of the Jaspersoft Database and User

Document ID : KB000057600
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary: 

This Technical document is a step by step of the creation of the Jaspersoft user "ppm_jaspersoft" and the creation or the database for Jaspersoft "ppm_jaspersoft" on the MS SQL server.

Instructions: 

1. Run the "SQL Server Management Studio" from your MS SQL server

2. From your SQL Server Management Studio use you credentials "sa" to enter

                Create Clarity Database Step 2.jpg

  

3. Under Security,  create a new Login. for Jaspersoft called "ppm_jaspersoft" using the configuration SQL Server authentication.

4. Right-click Databases and create the Jaspersoft Database "ppm_jaspersoft"

              Create Clarity Database Step 5.jpg

 

5. Run under a New Query :

    ALTER DATABASE ppm_jaspersoft SET ARITHABORT ON

    ALTER DATABASE ppm_jaspersoft SET ANSI_NULLS ON

    ALTER DATABASE ppm_jaspersoft SET QUOTED_IDENTIFIER ON

    ALTER DATABASE ppm_jaspersoft SET READ_COMMITTED_SNAPSHOT ON

    Use Master

    GRANT VIEW SERVER STATE TO ppm_jaspersoft

    EXEC SP_DEFAULTDB ppm_jaspersoft, ppm_jaspersoft 

 

6. Under the Security - Login with the user ppm_jaspersoft, in the properties change the Default database to "ppm_jaspersoft"

             Create Clarity Database Step 8.jpg