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
Procedure
- Select Connect using existing connection file (.cwc) or xBase Data Store as appropriate and click Next.
- In the Connection File or Descriptor field, click Browse to specify the location of the connection file (*.cwc) or descriptor file (storinfo.cws).
- Click Next, then click Finish on the confirmation dialog.
Connecting to a SQL data store
Prerequisites
- Open the SQL Server Configuration Manager.
- In the console pane, select the Protocols for your SQL server instance.
- In the details pane, right-click TCP/IP and click Enable.
You must restart the SQL Server service for these changes to take effect.
Procedure
- Select SQL Data Store and click Next.
- Complete the fields in the SQL Server Data dialog.
- Select the appropriate SQL product.
- Select or enter a server name. The drop-down list contains all available servers on the company network.
- Enter a unique database name. If possible, it should indicate that this is a Working Papers database.
- 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.
- Click Next. The completion page confirms if the connection was successful.
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).
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.
Note: To use IP addresses or port numbers, TCP/IP protocol must be enabled for the specified SQL Server.
Results
You are now connected to an existing data store.