Connecting to a SQL database in Data Aggregation Services requires that you have a Microsoft SQL Server installed on your computer.

Use DAS Management Console to add a new connection or to edit an already existing connection.

 

1. Connect to a local database

To add a connection to a SQL database select Data Connections in the left-side panel and click the Add button.

 

 

 

This will open the Add Connection dialog box below:

 

 

In the first text box type a name for the connection that you are about to set.

In the Provider Type box select Microsoft SQL Server like in the picture below:
 

 

In the Server Name section type the name of the host and the instance of the SQL server (for example localhost\SQLEXPRESS, where localhost is the name of the host and SQLEXPRESS is the instance of the SQL server).

Next, enter the name of the database you want to access from that server (in this example "Northwind").

You can log on to the server by using Windows Authentication or by using SQL Server Authentication, in which case you will have to enter the user credentials.

 

Note:

The server must be set to the correspondent authentication mode. In order to do this, open Microsoft SQL Server Management Studio Express, right click on the server name in the Object Explorer tree and select Properties.

In the Server Properties dialog box select the authentication mode from the Security menu like in the image below:

 

 

 

 

2. Connect to a remote database

To connect to a remote database follow the steps above, except for the Server Name section, where you will have to enter the IP address/name of the server and the instance of the SQL Server by following the format: "IP_address\instance_of_SQL_Server".

 

In the example below we configured a connection named "Connection2" to the "Northwind" database located on the server with the 192.168.1.110 IP address which has an SQLEXPRESS instance of the SQL Server installed. To log on to the server we used SQL Server Authentication.

 

 

 

Also, you have to make sure that the SQL Server is set to listen for remote client connections over TCP/IP or other protocols. In order to do this, open Surface Area Configuration for Services and Connections configuration tool and select Remote Connections from Database Engine. Select

the protocol you want to use for local or remote connections like in the picture below: