Troubleshooting connectivity issues in dedicated SQL pool (formerly SQL DW)

This article lists common troubleshooting techniques around connecting to your dedicated SQL pool database (formerly SQL DW).

Check service availability

Check to see if the service is available. In the Azure portal, go to the dedicated SQL pool (formerly SQL DW) you're trying to connect. In the left TOC panel, click on Diagnose and solve problems.

Select Resource health

The status of your dedicated SQL pool (formerly SQL DW) will be shown here. If the service isn't showing as Available, check further steps.

Service Available

If your Resource health shows that your dedicated SQL pool (formerly SQL DW) instance is paused or scaling, follow the guidance to resume your instance.

Screenshot shows an instance of dedicated SQL pool that is paused or scaling. Additional information about Resource Health can be found here.

Check for paused or scaling operation

Check the portal to see if your dedicated SQL pool (formerly SQL DW) instance is paused or scaling.

Screenshot shows how to check whether a data warehouse is paused.

If you see that your service is paused or scaling, check to see it isn't during your maintenance schedule. On the portal for your dedicated SQL pool (formerly SQL DW) Overview, you'll see the elected maintenance schedule.

Overview Maintenance Schedule

Otherwise, check with your IT administrator to verify that this maintenance isn't a scheduled event. To resume the dedicated SQL pool (formerly SQL DW) instance, follow these steps.

Check your firewall settings

The dedicated SQL pool (formerly SQL DW) database communicates over port 1433.  If you're trying to connect from within a corporate network, outbound traffic over port 1433 might not be allowed by your network's firewall. In that case, you can't connect to your logical server unless your IT department opens port 1433. Additional information on firewall configurations can be found here.

Check your VNet/Service Endpoint settings

If you're receiving Errors 40914 and 40615, see error description and resolution here.

Check for the latest drivers

Software

Check to make sure you're using the latest tools to connect to your dedicated SQL pool (formerly SQL DW):

  • SSMS
  • Azure Data Studio
  • SQL Server Data Tools (Visual Studio)

Drivers

Check to make sure you're using the latest driver versions.  Using an older version of the drivers could result in unexpected behaviors as the older drivers may not support new features.

Check your connection string

Check to make sure your connection strings are set properly. Below are some samples. You can find additional information around connection strings here.

ADO.NET connection string

Server=tcp:{your_server}.database.windows.net,1433;Database={your_database};User ID={your_user_name};Password={your_password_here};Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

ODBC Connection string

Driver={SQL Server Native Client 11.0};Server=tcp:{your_server}.database.windows.net,1433;Database={your_database};Uid={your_user_name};Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

PHP Connection string

Server: {your_server}.database.windows.net,1433 \r\nSQL Database: {your_database}\r\nUser Name: {your_user_name}\r\n\r\nPHP Data Objects(PDO) Sample Code:\r\n\r\ntry {\r\n   $conn = new PDO ( \"sqlsrv:server = tcp:{your_server}.database.windows.net,1433; Database = {your_database}\", \"{your_user_name}\", \"{your_password_here}\");\r\n    $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );\r\n}\r\ncatch ( PDOException $e ) {\r\n   print( \"Error connecting to SQL Server.\" );\r\n   die(print_r($e));\r\n}\r\n\rSQL Server Extension Sample Code:\r\n\r\n$connectionInfo = array(\"UID\" => \"{your_user_name}\", \"pwd\" => \"{your_password_here}\", \"Database\" => \"{your_database}\", \"LoginTimeout\" => 30, \"Encrypt\" => 1, \"TrustServerCertificate\" => 0);\r\n$serverName = \"tcp:{your_server}.database.windows.net,1433\";\r\n$conn = sqlsrv_connect($serverName, $connectionInfo);

JDBC connection string

jdbc:sqlserver://yourserver.database.windows.net:1433;database=yourdatabase;user={your_user_name};password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

Intermittent connection issues

Check to see if you're experiencing heavy load on the server with a high number of queued requests. You may need to scale up your dedicated SQL pool (formerly SQL DW) for additional resources.

Common error messages

Errors 40914 and 40615, see the error description and resolution here.

Still having connectivity issues?

Create a support ticket so the engineering team can support you.