CODEWITHSUNDEEP
sqlsql-serverazureazure-sql-databaseexternal-tables
Justin
Justin

Reputation: 332

External tables - Cross Database queries - Creating Database Scoped Credential

We are using SQL Server 2012 on AZURE. I would like to use queries from different databases; As azure does not allow us to query from different databases, I decided to create an external table.

However, when I try to create

CREATE DATABASE SCOPED CREDENTIAL cred WITH IDENTITY = '[email protected]', SECRET = 'the password belonging to the username to access the source database';

I get an error saying The specified schema name "[email protected]" either does not exist or you do not have permission to use it.

Could anyone let me know what the issue is?

Thank you, Justin

Upvotes: 0

Views: 753

Answers (1)

Leon Yue
Leon Yue

Reputation: 16401

Per my experience, you're using the AAD user '[email protected]' to create the external table. Just for now, create the CREATE DATABASE SCOPED CREDENTIAL doesn't support login with AD authentication, that's why we can't use AD user to create the cross database query.

Azure documents didn't talk more about this. Please user the normal another user and password.

Upvotes: 1

Related Questions