Configuring the SSIS Server Connection

book

Article ID: 179410

calendar_today

Updated On:

Products

Control Compliance Suite Windows

Issue/Introduction

 

Resolution

Configuring the SSIS Server Connection

You can modify the SQL server settings of the SSIS connection that is initially configured in the Install wizard.

The reporting database uses the SSIS platform to sync with the production database. The information that is provided on this panel is used to connect to the msdb database and deploy SSIS packages. You must enable the SQL agent on the selected database.

To configure the application server settings

  1. Go to Settings > Secure Configuration > SSIS Server Connection.

  2. Provide the following information:

    SQL Server

    Type the computer name that hosts the SQL Server.

    Instance name

    Type the SQL Server instance name.

    The default SQL Server instance name appears in the text box.

    Port number

    Type the port number of the SQL Server instance.

    If the port is enabled, the SQL Server default instance listens on TCP port 1433.

    Use SSL

    Check this option if you want SQL Server to use SSL to encrypt network transmissions independent of the network protocol.

    Use Windows NT Integrated Security

    Select this option if you connect to the SQL Server instance using Windows Authentication.

    Use a SQL user name and password

    Select this option if you connect to the SQL Server instance using SQL Server Authentication.

    You must specify the authentication details of the user in the respective text boxes.

    You cannot specify the following special characters for the User name and the Password fields:

    • Semi colon (;)

    • Double quotes (")

    • Curly bracket ({)

    • Single quotes (')

    • Hyphen (-)

    • Forward slash (/)


  3. Click Update to save.