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 toolset project master database. The master project database can be hosted on a different SQL Server or in a different server instance.
Manually adding databases to the AUTODESKVAULT SQL Instance is not recommended. Plant databases will not be backed up by Vault, and the AUTODESKVAULT SQL instance would be unsupported by Autodesk.
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.