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