Skip to content

Latest commit

 

History

History
45 lines (29 loc) · 2.36 KB

connection-to-sql-server.md

File metadata and controls

45 lines (29 loc) · 2.36 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic
Connection to SQL Server
Connection to SQL Server
chugugrace
chugu
03/14/2017
sql
integration-services
conceptual

Connection to SQL Server

[!INCLUDE oracle-cdc-retirement]

When a login without a database role that includes write permission (for example the db_owner role) to the MSXDBCDC database attempts to create an Oracle CDC instanced, the Connect to SQL Server dialog box is displayed.

In this dialog box you must enter the credentials for a login that has write permission to the MSXDBCDC database, such the db_owner database role to create the new Oracle CDC instance.

Enter the following information in the Connect to SQL Server dialog box.

Server Name

Type the name of the server where the [!INCLUDEssNoVersion] is located.

Authentication

Select one of the following:

  • Windows Authentication

  • SQL Server Authentication: If you select this option, you must type the Login and Password for the user in the [!INCLUDEssNoVersion] you are connecting to.

Options

Click the arrow to view available options to be configured. You can choose to leave these options with their default value. The available options are:

  • Connection Timeout: Type the time (in seconds) the program waits for the [!INCLUDEssNoVersion] connection to be established before producing a timeout error. The default value is 15.

  • Execution Timeout: Type the time (in seconds) that the program waits for SQL command execution to finish before producing a timeout error. The default value is 30.

  • Encrypt Connection: Select Encrypt Connection to ensure that the [!INCLUDEssNoVersion] connection that being established is encrypted to guarantee privacy.

  • Advanced: Click Advanced and type any additional connection properties into the Advanced Connection Properties dialog box, if necessary.

See Also

SQL Server Connection Required Permissions for the CDC Service