Not able to access Microsoft SQL Server 2012 installed on a remote desktop using Qlik Sense Desktop
I am using Qlik Sense Desktop on my windows 10 machine and want to integrate it with Microsoft SQL 2012 server which is installed on a Windows Server 2012 (currently I access windows server using remote desktop connection).
Using the OLEDB connection, I am able to successfully connect to the remote windows server but not able to load database into Qlik Sense.
I have following details with me:
- Remote Server IP address
- Remote Desktop Login Credentials
- SQL server name (it uses windows authentication)
- Database name
- Table name
Please let me know what is the issue because of which I am not able fetch data from SQL server.