AZ Sql Database Cross Database Query Identity syntax

• jmccoy-1028380

  Old Hand

  Points: 380

  More actions

  October 4, 2021 at 6:44 pm

  #3936387

  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?

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  October 5, 2021 at 7:10 pm

  #3936820

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Squire4Hire

  Newbie

  Points: 1

  More actions

  March 7, 2022 at 7:09 pm

  #3995254

  Did you ever get this figured out?