Shared Fabric Database Setup

This diagram gives an overview of how the shared fabric database is distributed to the client workstations.

Typically, a database administrator creates the database, configures it, and sets up the user accounts. The administrator, in accordance with the company policy, should set up a either a separate account for each user, or a single account for all users.

• Users (of DB Admin, Lotta, and VStitcher) all need read/write access.

• Our applications use standard SQL server ports. There are no special port requirements.

• No special database tools are required.

• Database size growth is linear relative to the number of fabrics.

1. Download the script to populate the database.

2. Run the script in the MS SQL server.

To set up a Windows client workstation:

1. Open whichever application - VStitcher or Lotta - you want to set up.

2. On the Main menu, click Edit, then Database Connection. The Database Connection dialog box is displayed.

   

3. Select SQL Server.

4. In Server Name, click , then click Browse for more.

   

   The drop-down is populated with database server locations.

5. In Server Name, click , then click the server.

   

6. In Database, type in the name of the database.

7. If not already selected, select Trusted Connection if you are using Windows authentication. Otherwise, type in the User Name and Password.

8. Click Test Connection.

9. If the test is successful, click OK

To set up a Mac client workstation:

1. Open whichever application - VStitcher or Lotta - you want to set up.

2. On the Main menu, click Lotta/vStitcher, then Database Connection. The Database Connection dialog box is displayed.

   

3. In Server Name, type in <server IP address>,<port number>.

4. In Database, type in the name of the database.

5. Clear Trusted Connection.

   

6. Type in the User Name and Password.

7. Click Test Connection

8. If the test is successful, click OK