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
Type the computer name that hosts the SQL Server.
Type the SQL Server instance name.
The default SQL Server instance name appears in the text box.
Type the port number of the SQL Server instance.
If the port is enabled, the SQL Server default instance listens on TCP port 1433.
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: