Set up the project master database for a vault project.
A vault project requires Microsoft SQL Server to host the project master database.
The project master database is like a non-vault project database that uses SQL Server. One important difference is that a vault project master database is updated only when a file is checked in to the vault. A non-vault project updates the project database as you work.
Autodesk Vault also uses SQL Server. But the vault does not use the same SQL Server database as the AutoCAD Plant 3D project master database. The master project database can be hosted on a different SQL Server or in a different server instance.
If you do specify the same server and instance that the vault uses, the master project database is not backed-up with Autodesk Vault.
SQL Server user logins and roles for the project master database are separate from Autodesk Vault users and roles.
Autodesk Vault roles are created using the Autodesk Data Management Server Console. You can use Microsoft SQL Server Management Studio to set up project master database server logins and roles.
The user creating the master project database must have Create Any Database service permission. After the database has been created, the database public role is granted Control permission.
For more information see FAQ: Using a Server-Based Database.
If you need to move or rename a project master database, you can edit (for example: using notepad) the database link DLK files in the local workspace. Before you can edit the files you need to use Autodesk Vault Client to un-hide and check out the DLK files.