I am trying to check out elastic query between two test instances we have in GCCH Azure. On the Microsoft learn page, it says that the first step is to create a master key and scoped credential as follows:
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'somegoodpassword';
CREATE DATABASE SCOPED CREDENTIAL [elastic_to_dev] WITH IDENTITY = 'ReportReader',
SECRET = 'somegoodpassword';
However, when I attempt to run this, I get the following errors:
Msg 15247, Level 16, State 1, Line 1
User does not have permission to perform this action.
Msg 15247, Level 16, State 1, Line 2
User does not have permission to perform this action
I am using the built in SQLAdmin account - which I assumed was an actual admin. Is there some higher level of "admin" that I need to do this? Or is this blocked because it is a GCCH instance?