Set up key for Query across cloud databases

Pat Snow 111 Reputation points
2022-08-25T11:00:15.847+00:00

Does the database scoped master key and credentials need to be set up on the source database?
elastic-query-vertical-partitioning

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 34,146 Reputation points MVP
    2022-08-25T11:12:34.617+00:00

    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

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.