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.