. Also, you can check if the scoped credential using the following query SELECT FROM sys. Jun 23, 2020 Step 1 - Create Master Key CREATE MASTER KEY; GO Step 2 - Create a Database Scoped Credential Create a credential called CrossDbcred that will map to the SQL Server login CrossDb, that maps to a user with read permissions in our external database and it has a password of Str0ngPssword. Mar 23, 2022 CREATE DATABASE SCOPED CREDENTIAL WorkspaceIdentity WITH IDENTITY &39;Managed Identity&39; GO -- SQL logins only -- create server-scoped credential for the containers in demo storage account -- SQL logins will use this credential in OPENROWSET function without data source that uses absolute file URL. Create a master key, if it is not there.