The default database is file-based (SQLite). You can, instead, choose to use a server-based database for improved multi-user performance and reliability. If you choose this option during project setup, keep in mind the following guidelines:
- Installing - Before setting up the project, you must install Microsoft SQL Server Express or Microsoft SQL Server on the machine that will host the project database. To download and install SQL Server Express, refer to the Microsoft web page here: http://www.microsoft.com/express/Database.
- Verifying - Make sure that the database is set up and running reliably. During project setup, you can also test the connection.
- Configuring the server to allow remote connections - By default, SQL Server 2008 Express is not setup to allow remote connections. To enable remote connections, use the SQL Server Configuration Manager. You perform this procedure on the server machine only.
Configuration: plant_project_sqlserver_and_vault_configuration.pdf (pdf).