Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Adding a SQL Server Data Source to the Jet Data Manager


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.


  1. In the Solution Explorer expand and Open the preferred Business Unit tab, and then right-click Data Sources.

  2. Select Data Sources, and then select Add SQL Server data source.



    The Add SQL Server Data Source dialog opens


  3. In the Name field, type a name for the data source. The name cannot exceed 15 characters in length.

  4. In the Server name field, enter the location of the database server.

  5. In the Database field, enter the name of the database or select it from the drop-down list.

  6. 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.

  7. 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.

  8. 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.

  9. In the Connection Timeout field, specify the number of seconds to wait before terminating the attempt to connect to the server.

  10. 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.

Was this article helpful?
0 out of 0 found this helpful