KB483903: How to use Microsoft Windows authentication to log into a Microsoft SQL Server database if the Intelligence Server is on a Windows machine.

The ODBC drivers shipped with Strategy provides support for Microsoft Windows/NT authentication to log into a Microsoft SQL Server database when the Intelligence Server is on a Windows machine. 
Implementing this authentication method requires the following steps:

1. Create a database connection and specify the Authentication Method to be 4 - Kerberos
2. Use Windows authentication login for the database instance and disable Kerberos authentication

 Step 1: Create a database connection

There are three ways to create an Open Database Connectivity (ODBC) connection:
 

Option 1: Create a Data Source Name (DSN) with the ODBC Data Source Administrator editor.

Option 2: Create a DSN with the Strategy Connectivity Wizard.

Option 3: Create a DSN-less connection with Windows ODBC driver

In either of the three ways you create an ODBC connection, you must specify the authentication method to be 
4 - Kerberos. For example, here is a connection string:
DRIVER={Strategy ODBC Driver for SQL Server Wire Protocol}; hostname=xxx.xxx.xxx.xxx; Port=1433; Database=xxxx; AuthenticationMethod=4;
 

 Step 2: Create a database instance

• Ensure the Database login in the Database Instance uses Windows authentication.
  

• Using the side navigation of the Project Configuration, locate Database instances > Authentication > Warehouse.
• From the Metadata authentication type drop-down, select Kerberos.
• Deselect the database instance that is connected to the SQL Server warehouse.