This is a legacy article for ShipWorks versions 3.4.9 and ealier.
If you have ShipWorks version 3.5 or later, please see the newer article: "Adding Computers to a ShipWorks Database"  

ShipWorks gives you the ability to connect additional PCs running the ShipWorks application across your Local Area Network (LAN) to the existing ShipWorks database. This configuration allows multiple users running ShipWorks to access the same information.


Requirements
1. All workstations running the ShipWorks software must be connected to the same Local Area Network (LAN). In most cases if all of your PCs are in the same building and are connected to the internet then all of your PCs are connected to the same LAN.
2. All PCs running the ShipWorks software must have the same version of the ShipWorks software installed. (see the section in this document ‘Checking Your Version of ShipWorks’ for more information).
3. Your Local Area Network cannot have a firewall in place that blocks the communication of the ShipWorks data across your network. This document will give you some basic troubleshooting tips to avoid Firewall conflicts. However, you may still need to disable or add an exception to any software or firmware Firewalls on your network.


What Information Will I Need?
Since ShipWorks connects across your Local Area Network you will need to know the following information in order to connect the new, client PC to the existing ShipWorks database.
1. The SQL Server instance name.
2. The ShipWorks database username and password.
3. The ShipWorks database name.


If you do not know this information don’t worry. You can get to most of it right within the ShipWorks application. Here’s how:
1. Open ShipWorks on the current ShipWorks machine.
2. Click on Manage > Change SQL Login.


Example 1.1: Connecting to SQL Server.


The above screen lists the information that you will need. Please make note of the SQL server instance, the database, and the username. The password field is encrypted for security purposes. You would have created this username during the initial installation of ShipWorks. If you do not have a record of this password, you will need to contact ShipWorks support.


3. Once you have noted the above information, you can click "Cancel" to close this screen.


Checking Your Version Number of ShipWorks
Before you install ShipWorks on any additional PCs on your network, check the version of ShipWorks you're currently running to be sure that all computers are running the same version. If they are not running the same version, we suggest upgrading all computers to the newest version of ShipWorks (available here). 


Since the newest version of ShipWorks contains significant changes to the database installation, there is a different process for connecting additional computers in ShipWorks 3.5. You will also need to enable your computer to allow remote connections


The steps below outline how to connect additional computers using ShipWorks 3.4.9 (and earlier), assuming all computers are running the same version. 

Please note: Make sure the main PC is running before attempting these instructions. 


1. On the computer(s) you want to add, open ShipWorks and click the ShipWorks logo. Select "Setup Database". 

Example 1.1: Setting up your database. 


2. On the "Database Setup" screen, select the option for "Connect to a Running Database". Then, click "Next".

Example 1.2: Connecting to your existing database. 


3. Use the drop-down menu to find the instance of ShipWorks you're using or simply type it in (see Example 1.1). Click "Next". 

Example 1.3: Connecting to your existing database. 


4. Enter your SQL Server information. By default, the username should be 'sa'. You set the password during your initial ShipWorks installation. Or, if you are running Windows as an administrator, select "Windows authentication". Click "Next". 

Example 1.4: Using your SQL / Windows authentication credentials to connect to your server PC. 

5. Select your database from the drop-down menu. The default database installed is "ShipWorks". Click "Next". 

Example 1.5: Selecting your database. 

6. Your database setup is complete. Click "Finish". You should now be connected to your main PC. 

Example 1.6: Completing your database connection.