SQL Administration Tasks for Autodesk Vault

 
 
 

Microsoft SQL Server creates a default administrator account named sa. This account has full administrative privileges as well as ownership of system tables. As long as you do not change the sa account password, the vault does not require you to use it. If the sa account password is changed, you must enter the new password when you perform certain administrative tasks such as attaching vaults.

SA Account Password Default

Microsoft SQL Server Requirements
Learn About SQL Server 2008 Express
Log into SQL Server
Install Microsoft SQL Server 2008 Prior to Installing Autodesk Vault Server

Configure Microsoft SQL Server for Multi-Site Support (Vault Collaboration and Professional Only)

If the installation is unable to find an installed version of Microsoft SQL, Autodesk Vault Server installs the Microsoft SQL 2008 Express service pack 2. You can install Microsoft SQL 2008 Standard or Enterprise Edition service pack 2 or Microsoft SQL 2008 R2 Standard or Enterprise Edition before installing the Vault server so that you do not have to perform the upgrade at a later time.

NoteThis installation process possibly requires the server to reboot multiple times. Please be sure that you are able to perform the necessary reboots. Also, if you use a custom password for the SQL SA account, specify this password during the installation of the Vault server.
Configure Remote SQL
Create Shared Network Folders