How to make Looker Studio connect to on-premise sql server without opening port to Looker Studio IP?

Looker Q&A Looker Studio
1

Hi,

I deploy SQL Server on a on-premise server. I read the docs, and know that I will need to open port 1433 to Looker Studio IP address. However, it violates security policy of our company. Is there any workaround like gateway, vpn … ?

2

You only need to open port 1433 if you’re connecting to Looker, not Looker Studio: Microsoft SQL Server (MSSQL)  |  Looker  |  Google Cloud

The Looker Studio to SQL Server docs are slightly different, and they have instructions for getting through a firewall: Connect to Microsoft SQL Server  |  Looker Studio  |  Google Cloud

Hope this helps!

3

Hi,

As I see in the docs you provided, I need to allow IP 142.251.74.0/23 of Looker Studio. Surely it’s against our security policy. I need a solution like agent or gateway from Looker, similar to PowerBI gateway.

4

Hm, I see what you mean. I think this is possible using a Looker (Google Cloud core) instance, as described in these docs: Access external services using private services access  |  Looker  |  Google Cloud

But I don’t think it’s possible with Looker Studio as-is.

1 Like