create external data source on azure sql server

Question

Hi Expert,

creating external data source on azure sql server but getting following error

Failed to execute query. Error: External data sources are not supported with type GENERIC.

do i have to write the credendials with something as am writing on sql server instance

also checked

SELECT SERVERPROPERTY ('IsPolyBaseInstalled') AS IsPolyBaseInstalled;

found 0 results that means polybase not installed... is there any way to write script on Azure SQL Server

CREATE EXTERNAL DATA SOURCE SQLServerInstance2

WITH (
  LOCATION = 'sqlserver://test.database.windows.net/test,1433',
  CREDENTIAL = SQLServerCredentials
) ;

Answer 1

Looks like the same problem as in:
https://learn.microsoft.com/en-us/answers/questions/66847/sql-server-create-external-data-source-err

Maybe you will find an answer over there.

---

Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members. If you have extra questions about this answer, please click "Comment".