October 4, 2021 at 6:44 pm
Attempting to follow directions from @SteveJones & MS documentation for setting up key for Azure Sql Server cross database queries.
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<master_key_password>';
CREATE DATABASE SCOPED CREDENTIAL ElasticDBQueryCred WITH IDENTITY = '<username>',
SECRET = '<password>';
We're receiving an error with the IDENTITY parameter. The examples look very straightforward but aren't working for us. Error: Incorrect syntax near 'IDENTITY'. Expecting CREATEDBOPT_BACKUPSTORAGEREDUNDANCY, CREATEDBOPT_CATALOGCOLLATION, CREATEDBOPT_FILESTREAM, CREATEDBOPT_LOGAPPLY, CREATEDBOPT_OTHER, or CREATEDBOPT_PERSISTENT_LOG_BUFFER.
We can't find any reference to this error or the parameter.
What are we missing?
October 5, 2021 at 7:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
March 7, 2022 at 7:09 pm
Did you ever get this figured out?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply