Advanced Connection Properties
Use the Advanced Connection Properties dialog box to add more connection parameters to the connection string.
The additional connection parameters can be any ODBC connection parameter that is supported by the SQL Server database instance you are using.
The parameters added using the Advanced Connection Properties dialog box are added to the parameters selected in the Connect to SQL Server dialog box.
The last instance of each parameter provided overrides any previous instances of the parameter. Parameters added using the Advanced Connection Parameters dialog box follow and replace the parameters provided in the SQL Server Connection dialog box. For example, if the SQL Server Connection dialog box specifies SERVER1 as the Server name, and the Additional Connection Parameters page contains ;SERVER=SERVER2, the connection will be made to SERVER2.
Parameters added using the Advanced Connection Properties dialog box are passed as plain text.
Important
Do not include login credentials in the Advanced Connection Properties dialog box. They will not be encrypted when they are passed across the network.
See Also
Access the CDC Designer Console
SQL Server Connection for Instance Creation
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for