Not able to connect with Microsoft OLE DB Provider for SQL Server
I am trying to connect to SQL Server with "Microsoft OLE DB Provider for SQL Server" in Qlik Sense. I have full access on SQL Server that I'm trying to connect to from Qlik Sense. But my OLE DB connection manager on Qlik Sense throws an error saying "Test Failed". I can't make out the cause of error. Could anybody help? Also, if I were to check the Qlik Sense log files for this failure details, which log file should I be looking in?