You can select the connection provider that you want to use to connect to the Microsoft SQL Server database. You can select either the ODBC or OLE DB connection type. You can also enable the Integration Service to use the Data Source Name (DSN) for the connection. Additionally, you can use NTLM authentication to authenticate the user who connects to Microsoft SQL Server.