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.
- 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.