Decide on a Local or Remote SQL Database

Use the details in this topic to determine whether a local or remote SQL database is right for your design environment.

Note: The remote database configuration is available in Autodesk Vault Professional.

Before you install the server:

Use a local or remote SQL database?

Local SQL Database

    By default, the server installer is configured to use a local database. If a compatible local SQL instance named 'AUTODESKVAULT' is detected, the server connects to the existing database. You are prompted to migrate the existing database once the installation is complete. If a local SQL instance named 'AUTODESKVAULT' is not detected or if the local instance is not compatible, you must install Microsoft SQL Express 2012 before continuing with the installation.

Remote SQL Database

    Reasons to use the remote SQL database configuration:

    • Performance improvements for single site environments.
    • Separation of services or components during installation or deployment.
      Note: For example, when you need to separate your Vault components for scaling and performance, including for replication.
      • Important: When using a remote SQL database, the SQL server must be on the same LAN as the Vault Server.

Use a Local Database

If a compatible local SQL database is detected, the name of the database instance is displayed. The installer automatically connects to an existing local database. You are prompted to migrate the data once the installation is complete. If no compatible SQL database was detected or if there is no local database and you are not connecting to a remote SQL database, use the following procedure to install a local SQL database.

Note: If a database is detected that is not compatible with the new version of the server, the existing database must be removed before the server can be installed.

Configure the Local SQL Database

  1. If you are installing Vault Workgroup or Professional, select the type of license server model you are using.
    Note: For more information, see Licensing.
  2. Enter the server name of the computer running the Autodesk License Manager.
  3. Click Next to go to Configure&Install page.
  4. The server is managed and maintained using the server console application. By default, the server console is installed in C:\Program Files\Autodesk\ADMS [Edition] [Year], depending on which data management solution you are installing. Click Browse to change the default installation location.
  5. Select the Vault product and unfold its configuration page.
  6. Select Local database.
  7. Click Browse to select the installation location for Microsoft SQL Server.
  8. By default, the database is installed in the same location as Microsoft SQL Server. Click Browse to change the location for the SQL database.
  9. Specify whether or not to create a desktop icon for the server console. By default, the desktop icon is created. The console can also be accessed from the Windows Start menu ► Autodesk ► Autodesk Data Management ► Autodesk Data Management Server Console.
  10. Before installation, a series of system diagnostics is performed to verify that the computer is configured properly for a successful server installation. The system tests return warnings or failures. The results of the tests are displayed in an interactive report. The report interface can be displayed:
    • Always show interactive interfaces
    • Show interactive interface only for failures
    • Show interactive interface only for failures or warnings

      • By default, Show interactive interface only for failures or warnings is displayed. Select a mode from the drop-down list.

  11. By default, the SQL sa account is used. You can specify a password for the SQL sa account or use the password set up by default. Turn off the Use default SQL user ID and password check box. Enter your SQL administrator user ID and password.
  12. The Autodesk Vault server requires a Windows user account. During installation, an account is created by default. To specify a new user ID and password, turn off the Use default Windows user name and password check box. Enter a Windows account user name and password for the account.
  13. If you are running another web application you can change the IIS port Vault server will use to communicate.
  14. Fold the configuration page to return to the Configure&Install page.
  15. On the Configure&Install page, click Install.
  16. If an existing database is detected, you are informed that the database may need to be migrated following the installation.
    • Click Yes to continue with the installation.
    • Click No to stop the installation and then remove the existing database.
  17. If an existing database was detected on the server, you are reminded once installation concludes that the database may need to be migrated.
    • Select Start the server console now and then click OK to launch the server console and migrate the existing database.
    • Select Run the server console at a later time and then click OK to conclude the installation without launching the server console. The first time you launch the server console, you will be prompted to migrate the existing database.

Use a Remote database

Note: The remote database configuration is available forAutodesk Vault Professional only.

When setting up a second site in a multi-site environment using a remote SQL database, a remote SQL instance named 'AUTODESKVAULT' must be available.

  1. In the Server configuration page, select Remote database.
  2. Enter the name of the computer containing the SQL instance to which to connect or click Browse to locate the computer on the network. Note: A SQL instance named 'AUTODESKVAULT' must exist on the selected computer. Do not include \\ in the computer name.
  3. When using a remote SQL instance, a shared network folder is required as a transition area between the SQL instance and the Autodesk Data Management Server. The shared network folder can be located on the same computer as the SQL instance or on a different computer and must be accessible by both the data management server and SQL. The space requirement for the shared folder is equal to the total of all database files. Choose a location with sufficient space and performance. Enter the UNC path to the shared network folder or click Browse to locate the shared folder on the network. Note: Both the user account under which the Autodesk Vault Server is running as well as the user account under which the SQL instance is operating need read/write access to the shared network folder.
  4. The server is managed and maintained using the server console application. By default, the server console is installed in C:\Program Files\Autodesk\ADMS [Edition] [Year], depending on which data management solution you are installing. Click Browse to change the default installation location.
  5. Before installation, a series of system checks are performed to verify that the computer is configured properly for a successful server installation. The system tests return warnings or failures. The results of the tests are displayed in an interactive report. The report interface can be displayed:
    • Always show interactive interface
    • Show interactive interface only for failures
    • Show interactive interface only for failures or warnings
    By default, Show interactive interface only for failures or warnings is selected. Select a mode from the drop-down list.
  6. By default, the SQL sa account is used. You can specify a password for the SQL sa account or use the password set up by default. Turn off the Use default SQL user ID and password check box. Enter your SQL administrator user ID and password.
  7. The Autodesk Vault server requires a Windows user account. During installation, an account is created by default. To specify a new user ID and password, turn off the Use default Windows user name and password check box. Enter a Windows account user name and password for the account.
  8. Fold configuration page to return to the Configure&Install page.
  9. On the Configure&Install page, click Install.

Account credentials

The Autodesk data management server requires a Microsoft SQL administrator account as well as an active Windows user account.

SQL credentials

When the data management server is installed, a SQL administrator account is required. If you are using an existing Microsoft SQL Server installation and you have an existing sa account and password, you can use the password for the existing SQL administrator account:

  • User ID: sa
  • Password: AutodeskVault@26200
Note: You cannot change the user ID for the SQL credentials.
  1. From the Configure&Install page, click Vault product to unfold its configuration page.
  2. Turn off the Use default SQL user ID and password check box.
  3. Enter the password for the existing sa account.
  4. Confirm the password.

Windows credentials

A default Windows user account is created during installation:
  • User ID: AutodeskVault
  • Password: Au1oDSK@26200
  1. From the Configure&Install page, click Vault product to unfold its configuration page.
  2. Turn off the Use default Windows user name and password check box.
  3. Enter the user name for the Windows user account.
  4. Enter the password for the Windows user account.
  5. Confirm the password.

Upgrade from a previous version of Vault

Before upgrading to a new version of the Autodesk Vault server. Use the ADMS Console to back up all vault and library data.

Note: If you upgrade from a compatible version of Vault, the installation attempts to upgrade your Vault without uninstalling your current Vault server.
  • Migrating from Vault 2015 product or Vault 2016 product can be done automatically during the installation of the equivalent Vault 2017 Edition.
  • Upgrading Vault Server 2017 to Vault Workgroup or Professional can be done automatically.
  • Migrating from older versions of Vault will require upgrading to the Vault [Edition] before installing Vault Server 2017.
  • Use the Autodesk Installer to install the new version of the data management server. If a compatible database is detected during installation, you are prompted to migrate the database to work with the new version of the server after installation is complete.
Note: If you are upgrading to a new version of the Autodesk Vault server, do not remove the SQL instance or file store. These two components comprise all of the library and vault data on the server. If detected during installation, you are prompted to migrate the data once installation is complete. Removing these components will result in loss of any data that has not been backed up using ADMS Console

Refer to the Vault Upgrade Guide for more information.

Existing databases

If an existing database is detected on the server, you are reminded once installation concludes, to migrate the database.

  1. Select Start the server console now and then click OK to launch the server console and migrate the existing database.
  2. Select Run the server console at a later time and then click OK to conclude the installation without launching the server console. The first time you launch the server console, you will be prompted to migrate the existing database.
Important: The existing database is not compatible with the new server until the data is migrated.

Supporting components

Once all the installation conditions are met, any missing supporting components are installed. The components that are installed depend on which components are already installed on the server computer. If the SQL server has not yet been installed on the server, it is installed now.

Uses for registration information

The information you provide will be used by Autodesk to customize and/or register your software, to improve and keep you informed about our products and services, and to ensure that you benefit from being an authorized Autodesk user. Autodesk does not sell or otherwise provide your information to anyone outside of Autodesk or our Authorized Business Partners. This information is subject to http://www.autodesk.com/privacy

Parent topic: Distributed Teams Installation

Related Concepts

Related Information