Can't Connect to Azure Blobl Storage using polybase through Microsoft SQL Server 2017

Question

Hello Polybase Support,

I am trying to connect to an external Polybase table on Microsoft SQL Server 2017 and every time I query the table I get the below error:

OLE DB provider "SQLNCLI11" for linked server "(null)" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "(null)" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 10060, Level 16, State 1, Line 0
TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Completion time: 2020-10-30T09:02:34.8292051-04:00
I researched some articles online and did the following steps
1)Created the Master Key to the database

2) Created Scoped Credentials to Blob storage

3) Set up CSV External Datasource

4) Created External Table then I trying to query the external table but getting the following error

OLE DB provider "SQLNCLI11" for linked server "(null)" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "(null)" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 10060, Level 16, State 1, Line 0
TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Completion time: 2020-10-30T09:02:34.8292051-04:00

I looked up how to fix this issue it was because the Polybase Engine wasn't running and TCP/IP needed to be enabled. So I went to the Microsoft configuration manager.

Started the Polybase engine rebooted my machine and I'm still getting the above error

I then read other instructions and enabled the firewall settings rebooted my machine and I'm still getting that connection error.

Are there any perquisites I am missing?

Answer 1

@Courtney Haedke
I am unfamiliar with the SQL server side of things, so have added the tag to see if we can get more responses from some SQL experts. I wanted to see if you can confirm you can connect to the blob storage account from your server. Make sure that the firewall on the storage account allows access and is not blocking. In this external blog post they connected to the storage account from SQL Server Management Studio, perhaps this is something you could test.

-----------

Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Hi @Courtney Haedke ,

...I then read other instructions and enabled the firewall settings rebooted my machine and I'm still getting that connection error.Are there any perquisites I am missing?

This is one connection issue.Try steps as next:

1. Close the firewall and antivirus softwares;
2. Enable TCP/IP protocols both on server and client side;
3. Make sure the port 1433 is enabled.

Client side:

Server side；

More information: mssqlserver-10060-database-engine-error, troubleshoot-connecting-to-the-sql-server-database-engine,resolving-could-not-open-a-connection-to-sql-server-errors

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Could you check once again if TCP/IP in SQL configuration manager is enabled.

Also, try restarting the main SQL Server service and later ensure that both polybase services are also running

Was your create external data source query successful?

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 4

I was getting this error message and was not sure but then I checked services and found that both the Polybase services were not running. Once I restarted, I was able to create

CREATE EXTERNAL DATA SOURCE ABCD
WITH (
TYPE = HADOOP,
LOCATION = 'wasbs://dwhbackup@xyz .blob.core.windows.net/',
CREDENTIAL = RST
);