Connected Workgroups

Configure connected workgroups to improve the performance of Microsoft SQL for remote sites.

Learn About Connected Workgroups

You must understand replication before you can understand how Connected Workgroups operate.

Replication

Replication is the process of copying data from one server to another server. The servers are usually located in two different physical locations. This setup allows a Vault environment in two locations so that it is not necessary to download large CAD files across a Wide Area Network (WAN) connection.

Workgroups

A workgroup is a group of users that share data via a local network.

A connected workgroup is a workgroup that can share data with other workgroups, using Microsoft SQL Publisher/Subscriber technology to support multiple database servers. This technology allows the replication of the SQL database at multiple locations.

When multiple Workgroups are authorized to work in the same vault, the workgroup must request ownership of files, folders, items, and change orders before it can modify them.

Requirements

• 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.
• SQL Server Replication must be enabled. If not, run the SQL installation package again to modify the installation on the SQL server and enable replication. (Feature Selection > Instance Features > Database Engine Services > SQL Server Replication.)

Recommendations

• 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.

Opening ports in Windows Firewall

• The AutodeskVault instance of SQL uses a Dynamic port.

  Find the port being used by your servers

  1. Open the SQL Server Configuration Manager
  2. Expand the SQL Server Network Configuration
  3. Select Protocols for AUTODESKVAULT
  4. In the right pane, double-click on TCP/IP
  5. Select the IP Address tab
  6. Scroll to the bottom of the list and find the port under the IP All section -> TCP Dynamic Ports
  7. Use this port number in the SQL AUTODESKVAULT line of the script below to open the dynamic port in the Windows firewall.

     Copy the following line into a batch file to open the necessary ports.

     @echo ========= SQL Server Ports ===================

     @echo Enabling SQLServer default instance port 1433

     netsh firewall set portopening TCP 1433 "SQLServer"

     @echo Enabling Dedicated Admin Connection port 1434

     netsh firewall set portopening TCP 1434 "SQL Admin Connection"

     @echo Enabling port for SQL Server Browser Service's 'Browse' Button

     netsh firewall set portopening UDP 1434 "SQL Browser"

     @echo Enabling SQL Server Dynamic port

     netsh firewall set portopening TCP <number> "SQL AUTODESKVAULT"

     @echo ========= Misc Applications ==============

     @echo Enabling HTTP port 80

     netsh firewall set portopening TCP 80 "HTTP"

  Troubleshooting Tips

  • Use the SQL Management Studio to verify that you can connect to the remote SQL servers.
  • Use a web browser to verify you have port 80 open.
  • Use Windows Explorer and the replication user credentials to verify each server has access to the snap shot share.

Connected Workgroups Overview

A connected workgroup is a configuration of file stores that have been replicated from one site to another and that are managed by the Microsoft SQL database. The following illustration shows a typical workgroup configuration. All sites in a single workgroup share the same Microsoft SQL server.

To allow sites to have their own database server to increase SQL performance, Vault uses connected workgroups. The following illustration shows a workgroup with two different sites connected to a second workgroup with a single site.

Create Connected Workgroups

The installation of a Connected Workgroup environment requires each component to be installed and configured in the correct order, as follows.

Configure the Publisher

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 on the computer where all the information is to be replicated from. This computer is known as the Publisher.
   • Make sure you enable replication during installation. See Install SQL Server.
   • Make sure you set up one or more shared network folders. See Use a Remote Database.
   • Autodesk recommends that you set up a "replication user" on the domain and make note of these credentials for the following steps. See SQL Administration for Vault.
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 Publisher.
4. After the Vault server is installed, start the Vault server console.
5. In the Vault server console, right-click Workgroups and select Enable Workgroup Replication.
   
6. Fill in the UNC path for the shared folder. For example: \\server\share\.
   
7. Enter the User ID, which is the user account configured for replication, and with full access to the shared folder, and click OK.
8. On the subscriber computer (the target for replicated data), install the same version of SQL that you just installed on the publisher.
   Note: Install this with a preconfigured instance named AutodeskVault and the same password as the publisher.
9. On the publisher, right-click Workgroups again in the Vault server console and select Add Workgroup.
   
10. Enter the appropriate information for the remote workgroup.

    If you created a replication user account, use those credentials under Remote Replication Credentials.

    

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.

Note: Once you have done this, you can install the Vault server console on the subscriber and enable vault replication.

Configure Firewalls

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.

Enable Vault Replication

Once you have configured the publisher, you can install the Vault server console on the subscriber and enable Vault replication.

Note: For subscribing locations with slower network connections it is better to configure the server at the same location as the publisher and ship the server. If shipping a subscribing server to a different location, do not disconnect it from the network for more than 14 days to allow a successful replication once reconnected to the network.

1. Install Autodesk Data Management Server on the subscriber and have it point to the subscriber SQL Server that is also installed there.
2. On the publisher in the ADMS Console, right-click Workgroups and select Manage Replication.
   
3. Select the Vault that you want to replicate.
   
4. Move the workgroups you want to replicate into the Replicated column using the >> button.
   
5. On the subscriber, open the ADMS Console and expand the Vaults node.
6. Right-click the appropriate Vault and select Vault Enabled to enable the vault.
   
7. Select the appropriate file store location when prompted.

Vault opens information dialog boxes that describe the vault synchronization frequency and tell you that the vault has been enabled.

Test Replication

1. Add a file to the publisher workgroup
2. Check the file out, modify it, and check it back in.
3. Move to a subscriber workgroup and transfer ownership of the file.
4. Repeat the same steps you did on the Publisher.
5. Optional: Transfer ownership back to the publisher when finished.

Back Up and Restore

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.

Note: The publisher name and name of the distribution database are stored in the backupcontents.xml file.

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