The Add Database dialog box allows adding an existing SQL database, or a new SQL database that will be created based on the information you enter.
To add a SQL database:
- Click Add in the Databases tab of the console. The Add Database dialog box appears.
- Check the Make this database the current PPM database box if you wish to make this database the current one.
- In the Type field, select SQL Server.
- In the Name field, enter the name of an existing database or specify a name for a new database.
- In the Server field, enter the name of the machine on which the Database Server is running. If the Database Server is running on the current machine, type: (local).
- In the User field, enter the user name of an existing database or specify a user name for a new database.
- In the Password field, enter the password of an existing database or specify a password for a new database. The password is limited to 14 characters.
- Click OK.