CODEWITHSUNDEEP
azureazure-sql-database.net-assemblypublic-key
Jayendran
Jayendran

Reputation: 10940

Creating Asymmetric Key in Azure SQL Server

I'm trying to create an asymmetric key from a file (Executable) in Azure SQL server. Basically I want to call Azure REST API from Azure SQL.

I tried with the Queries like 

CREATE ASYMMETRIC KEY SampleAzureKey FROM EXECUTABLE FILE ='c:\Test\SampleAzure.dll';


CREATE ASYMMETRIC KEY SampleAzureKey AUTHORIZATION deevita 
     FROM FILE = 'c:\Test\SampleAzure.dll'  
        ENCRYPTION BY PASSWORD = '<strongpass>';

But I got the error: 

File based statement options are not supported in this version of SQL Server.

I know that Azure SQL couldn't able to see my Location as c:\Test\SampleAzure.dll.

Upvotes: 0

Views: 529

Answers (1)

Jakub Szymaszek - Microsoft
Jakub Szymaszek - Microsoft

Reputation: 596

The FROM FILE clause you is not supported in the CREATE ASYMMETRIC KEY statement in Azure SQL Database. In addition, CLR is not supported either, so will not be able to call REST APIs. The steps in the Call Azure REST API from SQL Server article apply to SQL Server, not Azure SQL Database.

Thanks,

Jakub

Upvotes: 1

Related Questions