Step 1.1.3. Configure the Primary Data Source on the Primary Server

Primary Server/primary data source overview.

Primary Server/primary data source configuration.

Primary Server/Primary Data Source Overview

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

P

= Primary Server

S

= Secondary Server

Primary Server/Primary 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 primary server data source.

PRIMARY SQL SERVER

Description

(Optional) Description of the data source.

 

Server

The SQL Server for the primary server.

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

SQLSERVER1

  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 SQL Server data source is created and displays in the Data Source list on the System DSN tab.

More information

Step 1.1. Primary Server: Configure Windows ODBC data sources.