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
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"
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"
