topic Re: Connexion Qlik Sense saas to SQL Server in Connectivity & Data Prep

Connexion Qlik Sense saas to SQL Server

mdo — Wed, 03 Nov 2021 09:37:00 GMT

Hello folks

I try to connect Qlik Sense saas to SQL Server.

I had "Failed to locate Server/Instance Specified" error.

Can you help please?

Thank you

Re: Connexion Qlik Sense saas to SQL Server

Vinay_B — Thu, 04 Nov 2021 04:28:15 GMT

Hi @mdo,

If you're not using the IP address, try that and make sure it's the external IP address as the internal one will not work. Also, check out this video. It will walk you through the prerequisites for connecting to a local database from the cloud and gives open SQL credentials that you can use to test and ensure there is nothing happening with the tenant.

https://www.youtube.com/watch?v=RjdQu5ZjuRY&list=PLdnQXZq2xRoA7CBXn8wiYB184rP1HzRKe&index=5

I hope this helps!

Re: Connexion Qlik Sense saas to SQL Server

mdo — Mon, 15 Nov 2021 15:43:31 GMT

Hi @Vinay_B ,

Thank you for your help.

I'll let you know after the check.

Thanks

Re: Connexion Qlik Sense saas to SQL Server

mdo — Wed, 08 Dec 2021 11:42:04 GMT

Hi @Vinay_B ,

We try to follow your advice but it doesn't work. We have the same message.

Thank you