Working with Windows authentication
You can configure the Qlik Compose Microsoft SQL Server source to log in to Microsoft SQL Server using Windows authentication. If you choose this option, you also need to make sure that:
- The Microsoft SQL Server instance is set up to allow Windows log on.
-
The Compose user is specified as the "Log on as" user for the Qlik Compose Server service account.
OR
Microsoft SQL Server is configured to allow login for the Qlik Compose Server service account.