The default database is file-based (SQLite). However, you can 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, install Microsoft SQL Server Express or Microsoft SQL Server on the machine that hosts the project 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 does not allow remote connections. To enable remote connections, use the SQL Server Configuration Manager. Perform this procedure only on the server machine.