Using a Windows Service Account in a DB Connection

[#1]

I am new to Qlik Sense and trying to create a DB Connection using Windows Authentication.  I, myself, have access to the DB through my domain credentials (e.g. can login via SSMS).

When I create a connection in Qlik Sense with a new app and add a DB Connection I choose the OLE DB for Microsoft SQL Server.  However selecting Windows Authentication fails.  I'm forced to use a sql account. 

However, my real goal is to establish a library connection that uses a Windows Service account (domain login).  Either way, I don't understand why Windows Authentication that failed.

Please advise and thanks!

Paul

[#2]

Hi Paul,

We tried setting up ours in the same manner.  Basically running everything but the Repository DB using the service account.  When we did this the Proxy Service and Printing Service wouldn't restart.  Any additional ideas?