question

ManvirSingh-1181 avatar image
0 Votes"
ManvirSingh-1181 asked SeeyaXi-msft commented

Create External Data Source - No credentials are available in the security package

I am trying to create an external data source on my local 2019 SQL Server but getting the error

SQL Server Network Interfaces: No credentials are available in the security package

Here is my code

 CREATE MASTER KEY ENCRYPTION BY PASSWORD = N'Pa$$word';
 GO
    
 CREATE DATABASE SCOPED CREDENTIAL MasterDbCred
 WITH IDENTITY = 'DbDeployment',                    
 SECRET = '*HLt123&';                    
 GO
    
 CREATE EXTERNAL DATA SOURCE [Test_DataSource]
     WITH (
     LOCATION = N'DESKTOP-8SOPES5\\LOCALHOST',
     CREDENTIAL = [MasterDbCred]
     );


I am trying to add tables from a database into another one.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ManvirSingh-1181 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

According to the documentation , the syntax for LOCATION is:

LOCATION = '<prefix>://<path>[:<port>]

Thus, you seem to have it wrong.

I suspect that you also need CONNECTION_OPTIONS.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft edited

Hi @ManvirSingh-1181,

Can you post your complete error or a screamshoot? If you also have "Cannot generate SSPI context" in your error, then you need to modify your server authentication mode to hybrid authentication.
And did you see this?: https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-sql-server?view=sql-server-ver15#configure-a-sql-server-external-data-source

Best regards,
Seeya


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.