MS SQL Server connection

Connection owner - When you create the connection from the Connection Manager, the owner is automatically set to be the organization from which you create the connection. For connections enabled in the Integration Gallery, you are the default owner. Ownership can also be assigned to any organization of which you are an admin.

Display name - The display name is the name everyone in your organization will see for the connection.

Host/IP - the url for your database

Port (optional) - use if you connect through a special port

Database (optional) - You can specify it here or you can choose from a dropdown list when you create a dataset

Connection username - Your username for your data source

Connection password - Your password for your data source