You are here: All Help Topics > Engagement Management > Users > Connecting to a Data Store
-- How Do I? --

Connecting to a Data Store

Once the Data Store has been created, all computers that require access can be connected to the Data Store. The Data Store Connection Wizard is explained below. Click Attach in the Create/Connect tab of the Data Store Administration Tool to access the Data Store Connection Wizard. >>How Do I?

Note: Users can use the connection files created by administrators to connect or disconnect from Data Stores by double-clicking the connection or disconnection file.

Using a .cwc connection file or connecting to an xBase data store

  1. Select Connect using existing connection file (.cwc) or xBase Data Store as appropriate and click Next.
  2. In the Connection File or Descriptor field, click Browse to specify the location of the connection file (*.cwc) or descriptor file (storinfo.cws).
  3. Click Next, then click Finish on the confirmation dialog.

Connecting to a SQL data store

  • Your SQL Server must have the TCP/IP network protocol enabled to accept remote connections to a data store. To enable the TCP/IP network protocol:
    1. Open the SQL Server Configuration Manager.
    2. In the console pane, select the Protocols for your SQL server instance.
    3. In the details pane, right-click TCP/IP and click Enable.

    You must restart the SQL Server service for these changes to take effect.

    1. Select SQL Data Store and click Next.
    2. Complete the fields in the SQL Server Data dialog.
      1. Select the appropriate SQL product.
      2. Select or enter a server name. The drop-down list contains all available servers on the company network.
      3. Note: The wizard will try to connect to the default SQL Server instance. If you want to connect to a non-default instance, you must qualify the server name with the username and either the instance name (separated by a backslash, such as GARY1\SQL2015), or the IP address or port number (separated by a comma, such as GARY1, 49795).

      4. Enter a unique database name. If possible, it should indicate that this is a Working Papers database.
      5. Note: Ensure that the Auto Close property for the database is set to False. See Turning off Auto Close in the SQL Server for more information.

      6. Select either Network Server SQL Authentication or Windows Authentication and enter the information you will need to log on to the server. If Windows Authentication is selected, you will need to add a login in SQL Server Management Studio.
      7. Note: To use IP addresses or port numbers, TCP/IP protocol must be enabled for the specified SQL Server.

    3. Click Next. The completion page confirms if the connection was successful.

    You are now connected to an existing data store.

    Related Topics