Limitación de responsabilidad por el uso del Traductor Google. Haga clic aquí .
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.
Welcome
Welcome to the Data Store Connection Wizard
From the welcome page, select the type of connection you want to make.
Click on an area in the screen shot below to view its description
Choose Data Store
Choose Data Store
In the Connection File or Descriptor field, type or click Browse to specify the location of the connection file (*.cwc) or descriptor file (storinfo.cws).
Note: The field you see below will differ depending on if you are connecting via connection file or connecting to an xBase store.
SQL Server Data
SQL Server Data
Enter the following to connect to a SQL Server.
Click on an area in the screen shot below to view its description
Select the SQL product being used to create the tables. The choices are:
- Microsoft SQL Server 2008
- Microsoft SQL Server 2008 Express
- Microsoft SQL Server 2012
- Microsoft SQL Server 2012 Express
- Microsoft SQL Server 2014
- Microsoft SQL Server 2014 Express
Select or enter a server name. The drop-down list contains all available servers on the company network. Select the one on which the SQL databases to be used are located.
Data Store will try to connect to the default SQL Server instance running on the server. If there are multiple SQL Server instances running on the same server and you want to connect to the non-default instance you must quality the server name with either:
-
An instance name separated from the server name by a backslash.
Example: "GARY1\SQL2014"
Where SQL2014 is the name of the non-default SQL Server instance running on server GARY1.
-
A port number separated from the server name by a comma.
Example: "GARY1, 49795"
Where 49795 is the port number used by the SQL Server instance running on server GARY1.
Note: To use IP addresses or port numbers, TCP/IP protocol must be enabled for the specified SQL Server.
Enter a unique database name. This database name should indicate that this is a Working Papers database if possible and should follow your organization’s standards for database names.
Note: If you are using a SQL database, you must 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.
Enter the information that you will use to log on to the server.
Select one of the following options:
- Use Network SQL Server Authentication
- Use Windows Authentication
Notes
- If Windows Authentication is selected, the sup login may not be recognized as administrator. You will need to add a login in SQL Server Management Studio.
- Users who will be performing administration on the SQL store with the Data Store Administration Tool must have db_owner rights. All other users must be granted db_datareader and db_datawriter rights.
Complete
Connection Complete
The completion page confirms if the connection was successful.
Notes
- Users can use the connection files created by administrators to connect or disconnect from Data Stores by double-clicking the connection or disconnection file.
- Ensure your SQL Server is configured to accept remote connections before connecting to a Data Store or else users may experience difficulty connecting to the store. To enable remote connections you need to run the SQL Server Configuration Manager tool (bundled with the SQL Server installation package) and in the section of SQL Server Network Configuration | Protocols for 'Your SQL Instance Name', make sure TCP/IP is enabled.
Accessing the Data Store Connection Wizard
In the Create/Connect tab, click Attach.
