大网数据广告活动
数据库与应用安全

Error 105005 when you do CETAS to blob storage

· 52CE 我爱测

This article provides resolutions for the error that occurs when you do a CETAS operation to Azure Blob storage by using PolyBase.

This article helps you resolve the problem that occurs when you do a CREATE EXTERNAL TABLE AS SELECT (CETAS) operation to Azure Blob storage by using PolyBase.

Original product version:   SQL Server Parallel Data Warehouse (APS)
Original KB number:   3210540

Symptoms

When you do a CREATE EXTERNAL TABLE (Transact-SQL) operation to Azure blob storage by using What is PolyBase? from the Microsoft SQL Server Parallel Data Warehouse (PDW) appliance, the Azure service returns the following error message:

Msg 105005, Level 16, State 1, Server [Server name], LineLineNumber
CREATE EXTERNAL TABLE AS SELECT statement failed as the path name 'wasbs://[Container name]@[Storage name].blob.core.windows.net/[Location name]' could not be used for export.
Please ensure that the specified path is a directory which exists or can be created, and that files can be created in that directory.

Cause

This error occurs because PolyBase can't complete the operation. The operation failure can be due to one or both of the following:

  • Network failure when you try to access the Azure blob storage on the required network ports.
  • The configuration of the Azure storage account

Resolution

To fix this issue, make sure that the following prerequisites are met.

  • Network requirements:

    Allow local firewall ports 80 and 443 outbound to *.blob.core.windows.net from CTL01 node through provided internet connectivity.

  • Storage account requirements:

    • Make sure that the storage account is configured as a standard storage account that uses either of the following storage replication options (Classic or Resource Manager based):

      • Standard Locally Redundant Storage (Standard-LRS)
      • Standard Geo-Redundant Storage (Standard-GRS)
    • For Resource Manager based storage accounts:

      Configure the account for General Purpose.

Note: When you use Resource Manager Based storage accounts, make sure that the account is configured for General Purpose. If you use Blob Store, an error message will be returned.

More information

For more information about PolyBase, see the following Azure articles:

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 05/09/2025
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。