CREATE EXTERNAL DATA SOURCE ERROR on Local Host

Brent Carpenetti 21 Reputation points
2022-11-15T19:31:40.26+00:00

https://stackoverflow.com/questions/61100707/polybase-to-connect-local-csv-file

The above link shows how to create an external datasource / table from a local csv file.

Right now my current set up is rendering an error message consistent with the link below.

https://social.msdn.microsoft.com/Forums/en-US/93140719-ccb2-4b16-8a5c-09220c719fa4/sqlserver-2019-create-external-file-format-error?forum=sqldatabaseengine

Except, I would think a local odbc connection wouldn't need any specific authentication credentials (although I have created and stored credentials as suggested in the first link).

260671-screenshot-2022-11-15-112856.png

What am I missing?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,995 questions
0 comments No comments
{count} votes

Accepted answer
  1. PandaPan-MSFT 1,921 Reputation points
    2022-11-16T06:21:57.557+00:00

    Hi @Brent Carpenetti ,
    I think the causing reason is that this can only be used by SQL authentication. And you can see from this link:https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=sql-server-ver16&tabs=dedicated
    260739-image.png
    260778-image.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Brent Carpenetti 21 Reputation points
    2022-11-16T00:04:41.133+00:00

    The issue appears to be that the command was run from ADS with the user account instead of in SSMS with system admin.

    I'm not sure why that would make a difference as my user has system admin.

    260702-screenshot-2022-11-15-112857.png

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.