Cannot connect: connection refused

How to fix this below error ?

Cannot connect: connection refused: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Cannot open server ‘dbsvr-azuredb-streamanalytics’ requested by the login. Client with IP address ‘52.1.5.228’ is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect. ClientConnectionId:9c1b0adf-9c47-4a18-a8b4-da449082dba5

JDBC string: jdbc:sqlserver://dbsvr-azuredb-streamanalytics.database.windows.net:1433;database=DB-CustomerAnalytics;encrypt=true;trustServerCertificate=true

0 1 1,386
1 REPLY 1

It sounds like you need to white list the ip address of looker instance on your database server. This sentence appears to tell you how to do it: "To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. "

It looks like this might tell you more: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure

Top Labels in this Space
Top Solution Authors