If you want to use a Microsoft SQL Server connection without using a Data Source Name (DSN less connection), you must configure the odbcinst.ini environment variable.

If you use a DSN connection, you must add the entry EnableQuotedIdentifiers=1 to the ODBC DSN. If you do not add the entry, data preview and mapping run fail.

You can use the Microsoft SQL Server NTLM authentication on a DSN less Microsoft SQL Server connection on Microsoft Windows.

You cannot use an SSL connection on a DSN less connection. If you want to use SSL, you must use the DSN connection. Enable the

Use DSN

option and configure the SSL options in the odbc.ini file.

If the Microsoft SQL Server uses Kerberos authentication, you must set the GSSClient property to point to the Informatica Kerberos libraries. Use the following path and file name: Create an entry for the GSSClient property in the DSN entries section in odbc.ini for a DSN connection or in the SQL Server wire protocol section in odbcinst.ini for a connection that does not use DSN.