AZ Sql Database Cross Database Query Identity syntax

  • 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?

     

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

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply