Add a SQL Server Data Source to the Jet Data Manager
Overview
Data sources contain the data that you want to retrieve and use for analysis. This article details the required steps to add a SQL Server data source.
The Jet Data Manager supports SQL Server databases created using SQL Server 2005 or later.
Your license determines the number and type of data sources that you can connect to. A standard license permits a connection to one data source. Additional connectors can be purchased to permit the use of additional data sources.
Process
In the Solution Explorer expand and open the preferred Business Unit tab, and then right-click Data Sources.
-
Select Data Sources, and then select Add SQL Server data source.
The Add SQL Server Data Source dialog opens
In the Name field, type a name for the data source. The name cannot exceed 15 characters in length.
In the Server name field, enter the location of the database server.
In the Database field, enter the name of the database or select it from the drop-down list.
Specify the authentication mode. The default setting is Windows authentication. If you choose SQL Server authentication, you are prompted for a user name and a password.
Click Test Connection to verify that the connection is working, and then click OK. The data source is added to the Data Sources folder in the project tree.
-
In the Command Timeout field, specify the number of seconds to wait before terminating the attempt to connect to the database.
Note: The recommended setting for this is 0 seconds to disable the timeout
In the Connection Timeout field, specify the number of seconds to wait before terminating the attempt to connect to the server.
If you want to add additional connection strings, click the Additional Connection Properties button. In the Connection String Properties window type the preferred connection strings and then click OK