To create the database:
- Log in to the server as the SA user.
- Open Microsoft SQL Server Management Studio. Go to \database\scripts\install\PPM_<release level> and run the ssppm_init_db.sql script. This script creates a database called PMDB. If you want to use a different database name, modify the line in the script as follows:
set @DB_NAME='<database_name>'where
<database_name>is the name for the databaseNotes:
- Instead of running the ssppm_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, or public 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.