Decide on a Local or Remote SQL Database (Vault Collaboration and Professional Only)

Use a local or remote SQL database(Vault Collaboration and Vault Professional Only)?

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, then Microsoft SQL Express 2008 SP2 is installed.

Remote SQL Database (Collaboration and Professional Only)

Reasons to use the remote SQL database configuration:

• Performance improvements for single site environments.
• Multiple site or connected workgroup environments. When setting up a second or subsequent site in a multi-site environment, a remote SQL instance named 'AUTODESKVAULT' must be available. The sites connect to the remote SQL instance.
  Note: For more information on setting up an environment comprised of more than one site, see What is a Multi-Site Environment?.

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.

Configure the Local SQL Database

1. If you are installing Vault Workgroup, Collaboration, 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 (Vault Collaboration and Vault Professional Only)

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.