Set up key for Query across cloud databases

Pat Snow 111 Reputation points

Does the database scoped master key and credentials need to be set up on the source database?

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 31,266 Reputation points MVP

    You need to do that on the origin database not in the remote database. Imagine you need to query from an Azure SQL database named OriginDatabase a table on another database named RemoteDatabase. You create the master key and the database scoped credential on the OriginDatabase only.

    0 comments No comments

0 additional answers

Sort by: Most helpful