To create the database:
- Register to the server as SA user.
- Open Microsoft SQL Server Management Studio. Go to \database\scripts\install\PM_<release_level> and run the sspm_init_db.sql script. This script creates a database called PMDB. If you want to change it, you must modify the sspm_init_db.sql script.
Notes:
- Instead of running the sspm_init_db.sql script, you can manually create a database named PMDB with a data file of 500 MB or more and a log file of 200 MB or more.
- Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
- You can change the initial data file and log file sizes and increase or decrease these amounts depending on how much data you plan to store in the database. You can also select the Automatically Grow File option to specify that these values automatically increase based on need.