We initially loaded our Qlik Sense onto the same server as of SQL Server database. We now moved Qlik sense to its own server. Both servers are running in Azure.
I cannot get Qlik sense to connect to our SQL Server database now that they aren't on the same server. I am trying to use the Microsoft OLE DB provider for SQL Server and in the data source I have tried using the IP address of the SQL Server\DB Name, I have tried just the DBName but cannot get connected.
Any help is appreciated. Thanks