无法在SQL中创建外部数据源(Can't CREATE EXTERNAL DATA SOURCE in SQL)

 我正在尝试创建一个外部数据源来访问Azure Blob存储。 但是，我在创建实际数据源时遇到问题。 
 
 我按照此处的说明操作： 在azure blob存储中批量访问数据和创建外部数据源的 示例 - transact sql 。 我在使用Windows身份验证的客户端计算机上通过SSMS访问的VM上使用SQL Server 2016而没有任何问题。 说明说创建此外部数据源适用于SQL Server 2016和Azure Blob存储。 
 
 我创建了万能钥匙： 
 
CREATE MASTER KEY ENCRYPTION BY PASSWORD = <password>
 
 和，数据库范围的凭据 
 
CREATE DATABASE SCOPED CREDENTIAL UploadCountries  
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = <key>;
 
 我通过查询sys.symmetric_keys和sys.database_scoped_credentials验证了数据库中存在的这两种情况。 
 
 但是，当我尝试执行以下代码时，它说'EXTERNAL'附近的语法不正确 
 
CREATE EXTERNAL DATA SOURCE BlobCountries
WITH  (
    TYPE = BLOB_STORAGE,
    LOCATION = 'https://<somewhere>.table.core.windows.net/<somewhere>', 
    CREDENTIAL = UploadCountries  
);
 
 感谢您的想法和帮助！ 
 
 史蒂夫。 

I'm trying to create an external data source to access Azure Blob Storage. However, I'm having issues with creating the actual data source.
 
I've followed the instructions located here: Examples of bulk access to data in azure blob storage and Create external data source - transact sql. I'm using SQL Server 2016 on a VM accessing via SSMS on a client machine using Windows Authentication with no issues. Instructions say creating this external data source works for SQL Server 2016 and Azure Blob Storage.
 
I have created the Master Key:
 
CREATE MASTER KEY ENCRYPTION BY PASSWORD = <password>
 
and, the database scoped credential
 
CREATE DATABASE SCOPED CREDENTIAL UploadCountries  
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = <key>;
 
I have verified both of these exist in the database by querying sys.symmetric_keys and sys.database_scoped_credentials.
 
However, when I try executing the following code it says 'Incorrect syntax near 'EXTERNAL'
 
CREATE EXTERNAL DATA SOURCE BlobCountries
WITH  (
    TYPE = BLOB_STORAGE,
    LOCATION = 'https://<somewhere>.table.core.windows.net/<somewhere>', 
    CREDENTIAL = UploadCountries  
);
 
Your thoughts and help are appreciated!
 
Steve.

原文：https://stackoverflow.com/questions/46739126