About Connected Workgroups

• For servers not in the same domain, add a local Windows account (not a domain account) for each agent at the appropriate nodes (use the same name and password at each node). For example, AutodeskRep.
• A shared folder on the Publisher where replication snap shots are stored and shared to remote SQL servers.
• A Windows account on the Publisher that has Read/Write permissions to the snap shot share.
• A Windows account that has Read permissions to Publisher's snap shot share.
• Server participating in the replication environment must be able to resolve remote servers by NetBIOS name.
• SQL and http ports need to be open in firewalls for communication between servers.

• Servers are in the same domain or two-way trusted domains.
• Servers are assigned static IP address.
• Use 1 domain user account for replication and snap shot access.

Vault does not support connected workgroups on Microsoft SQL express. The full version of Microsoft SQL must be installed with a database instance named "AutodeskVault" before installing the Vault server. ) For more information, see Pre-Install Microsoft SQL.

1. Install MS SQL.
2. After SQL is installed, log into the SQL AutodeskVault Instance through the SQL Server Management Studio. Right click the top level server name and select properties. Under the Connections tab, make sure that the option nocount is not selected.
3. Install Vault server on the computer where all the information is to be replicated from. This computer is known as the Publisher.
4. After the Vault server is installed start the Vault server console.
5. Fill in the UNC path for the shared folder. For example: \\server\share\.
6. Enter the User ID, which is the user account configured for replication, and with full access to the shared folder.
7. Enter and confirm the network password for the User ID entered.
   
8. Click OK.

Configure Firewalls

Before adding a workgroup be sure that the SQL server can communicate with the Vault server through the firewall. This can be done by allowing an exception for the SQL executables sqlbrowser.exe and sqlserver.exe.

After the Publishing server is set up and configured, you can set up the subscribing servers. When configuring the subscribing servers the publishing server installs the Vault server databases to the subscribing server over the network.

1. Install the same version of SQL that was used on the publisher with a preconfigured instance named AutodeskVault, and the same password as the publisher.
2. From the publisher, launch the Vault server console.
3. In the left pane of the server console, right-click the Workgroups node, and select Add Workgroup.
   
4. Enter a name for the new workgroup.
5. Enter the name of the computer with the new instance of SQL was installed.
6. Enter the User ID and Password for the network user setup to run replication.
   
7. Click OK. A background process configures the remote SQL server as a subscriber, and starts to replicate the KVM database from the publisher. Once the secondary server has completed its configuration, it is added to the Workgroups tree in the console.
   NoteThough the configuration is complete, the replication may not be complete. Verify that the replication is complete before you move to the next step. AFter the publisher finishes installing the databases to the subscriber, the Vault server console can be installed on the subscribing server.
8. Install Autodesk Data Management Server on the subscriber.

Once a Connected workgroup has been configured the last step is to enable which vaults are replicated. This can be configured using the Manage Replication tool.

1. Select the primary Workgroup.
2. In the right pane right-click the Vault to manage and select Manage Replication.
   
3. Select the workgroup from the "Not replicated" column, presses the >> button to add it to the Replicated column.
   
4. Click OK.

Perform all backup and restore operations from the publisher site. If it becomes necessary to restore a subscriber, remove that subscriber from the connected workgroup environment, rebuild the subscriber server, and add it back to the connected workgroup environment.

Vault backs up the normal KVM and Vault databases, and the SQL master database, the msdb database, and the replication distribution database. The default name of the replication distribution database is AutodeskReplication.

Vault does not allow you to restore a connected workgroup environment. The databases necessary for restoring a connected workgroup environment are backed up, and can be restored manually if necessary.

Back up

Use the Vault server console to create a backup of the Vault server at the publisher site.

Perform a backup when you :

• Change a workgroup.
• Add a workgroup.
• Delete a workgroup.
• Rename a workgroup.

Restore

To restore an Autodesk Vault Professional environment using the backup and restore tools provided by the server console, the publishing server must be restored and all subscribers must be added as if they were never part of the environment.

The following rules apply when manually restoring the Vault connected workgroup publisher while maintaining the existing subscribers:

• The publisher can only be restored to a server with the same name.
• Subscribers should be on the same version of Autodesk Vault Professional. No data migration should be needed.
• The backup should not be more than 14 days old.
• Start each database server in single-user mode.
• Restart the database server instance after each database is restored.

Restore the databases in the following order:

1. Master
2. MSDB
3. AutodeskReplication
4. KVM
5. Vaults