Issue connecting to Azure SQL Data Warehouse

Question

I'm having an issue connecting to an Azure SQL Data Warehouse instance from within a corporate firewall.

I can connect to the server itself (i.e. the master database), and can telnet to both the server name and IP on 1433, but when I attempt to connect to the SQL DW database I get "No connection could be made because the target machine actively refused it" (SQL Server Error 10061).

This isn't a permissions issue - the user has access to the database, and I can connect to it, using the same credentials, from other networks. Neither does it appear to be a firewall issue since I can connect to the master database.

Another peculiar symptom is that the version number of the server gets reported differently from different clients - variously as 12.0.2000.8 and 13.0.702 - although this doesn't appear to make any difference to connectivity.

This happens in VS 2013, VS 2015, SSMS 2012 and SSMS 2014.

Does anyone have any idea what might be causing this?

Regards,

Matt

We also have this problem. The SQL Managment Studio that reports 13.0.702 can't see columns tree node when you expand out tables. — adudley
@JosephIdziorek, no - we've got connectivity now. We needed to open port 135 (tcp) on the client side. I'm not sure why. — Matt Connolly

Nicolle Anger - MSFT Nicolle Anger - MSFT · Accepted Answer · 2015-12-05T00:00:05

You might be running into firewall issues from Azure. Did you already run through these steps: https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-get-started-provision/#step-4-configure-server-firewall-access-for-your-client-ip

Issue connecting to Azure SQL Data Warehouse

1 Answers