Shared Fabric Database Setup

Susan Kehila

Updated November 11, 2024 11:35

This topic includes information about setting up a shared fabric database. For details, expand the following:

Database Setup Notes

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.

Setting Up a Windows Client Workstation

To set up a Windows client workstation:

Open whichever application - VStitcher or Lotta - you want to set up.
On the Main menu, click Edit, then Database Connection. The Database Connection dialog box is displayed.
Select SQL Server.
In Server Name, click , then click Browse for more.

The drop-down is populated with database server locations.
In Server Name, click , then click the server.
In Database, type in the name of the database.
If not already selected, select Trusted Connection if you are using Windows authentication. Otherwise, type in the User Name and Password.
Click Test Connection.
If the test is successful, click OK.

Setting Up a Mac Client Workstation

To set up a Mac client workstation:

Open whichever application - VStitcher or Lotta - you want to set up.
On the Main menu, click Lotta/VStitcher, then Database Connection. The Database Connection dialog box is displayed.
In Server Name, type in <server IP address>,<port number>.
In Database, type in the name of the database.
Clear Trusted Connection.
Type in the User Name and Password.
Click Test Connection.
If the test is successful, click OK.

Shared Fabric Database Setup

Comments

Articles in this section