Step 1.2.4. Configure the Secondary Data Source for the Secondary Server

Secondary Server/secondary data source overview.

Secondary Server/secondary data source configuration.

Secondary Server/Secondary Data Source Overview

The SQL Server storing data from the secondary server is the secondary data source.

P

= Primary Server

S

= Secondary Server

Secondary Server/Secondary Data Source Configuration

  1. Enter specifications in the Create a new Data Source to SQL Server dialog box as follows:

Field

Description

Example

Name

Unique  for the secondary server data source.

SECOND SQL SERVER

Description

(Optional) Description of the data source.

 

Server

The SQL Server for the secondary server.

Note: Select the SQL Server  from the drop down menu.

SQLSERVER2

  1. Click Next.

  2. Enter specifications in the second Create a new Data Source to SQL Server dialog box as follows::

Check:

A

With SQL Server authentication using a login ID and password entered by the user.

B

Connect to SQL Server to obtain default settings for the additional configuration options.

 

The following fields are enabled.

 

Login ID

Required to access to database in the Login ID field.

 

Password

Password required to access the database

  1. Click Next.

  2. Enter specifications in the third Create a new Data Source to SQL Server dialog box as follows:

A

Check Change the default database to enable entry for default database.

B

Select the default database from the drop-down of default databases connected to the selected data source.

  1. Click Next.

  2. Enter specifications in the fourth Create a new Data Source to SQL Server dialog box as follows:

Check Perform translation for character data.

  1. Click Finish.

An ODBC Microsoft SQL Server Setup screen displays the details of your configuration.

  1. Click OK if the specifications are correct.

Result: The SECOND SQL Server displays in the System DSN tab.

More information

Step 1.2. Secondary Server: Configure Windows ODBC data sources.