Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft SQL Server Connector
  3. Connections for Microsoft SQL Server
  4. Synchronization tasks with Microsoft SQL Server Connector
  5. Mappings and mapping tasks with Microsoft SQL Server Connector
  6. Replication tasks with Microsoft SQL Server
  7. Data type reference

Microsoft SQL Server Connector

Microsoft SQL Server Connector

Windows authentication

Windows authentication

The following table describes the basic connection properties for Windows authentication:
Property
Description
Domain
Applies to Windows Authentication v2.
The domain name of the Windows user.
Host
Name of the machine hosting the database server.
To connect to Microsoft Azure SQL Database, specify the fully qualified host name.
For example,
vmjcmwxsfboheng.westus.cloudapp.azure.com
.
Port
Network port number used to connect to the database server.
Default is 1433.
Instance Name
Instance name of the Microsoft SQL Server database.
Database Name
Database name for the Microsoft SQL Server target connection. Database name is case-sensitive if the database is case-sensitive. Maximum length is 100 characters.
Database names can include alphanumeric and underscore characters.
Schema
Schema used for the target connection.
Code Page
The code page of the database server.

0 COMMENTS

We’d like to hear from you!