Specifies whether to use the default SQLite local database or SQL Express server database. For more information, see the white paper describing how to convert from a local database to a server database.
SQL Server Database Name
SQL Server setup now has a Test Name button.
The default database name is now based on the host computer name and project name, allowing the database administrator to more easily identify which plant project the SQL Server database belongs to.
This applies to all SQL Server projects, not just vault projects.
- Single User - SQLite local database
- Specifies that the project is to use the default database. No further configuration is required for this option.
- Multi-User - SQL Server Database
- Specifies that the project is to use the server database. When you choose this option, you can add information about the server, name, database prefix, and authentication. For guidelines, see FAQ: Using a Server-Based Database.
- 1 - 2 active users in the project: SQLite
- 3 or more active users: SQL Server
A good rule of thumb is to avoid using SQLite in situations where the same database is accessed directly (without an intervening application server) and simultaneously from many computers over a network.
Note that using Vault for a Plant 3D project requires also using SQL Server.
- SQL Server Name
- Specifies the server name. You can enter a name or select from the list of available servers. Click Test Connection to make sure you can make a connection.
- Test Connection
- Connects to SQL Server using the name and authentication provided.
- Database name prefix
- Specifies the database name prefix. This database name prefix is used to name a database for each project part. For example, if prefix is specified, prefix_PnId, prefix_Piping, prefix_Ortho, prefix_Iso, and prefix_Misc databases are created.
- Test Name
- Verifies that the database does not already exist on the server.
- Authentication
- Specifies whether to use Window or SQL Server authentication. If you select Windows authentication, no further information is needed. If you select SQL Server information, however, you must enter the appropriate user name and password. Also, users must enter credentials when opening a project.
- Username/Password
- Specifies your username and password for the SQL Server.