SQLTeam.com | Weblogs | Forums

Database_scoped_credentials

How can I insert a record in sys.database_scoped_credentials

I created a new database in Azure and I get the following error whey I try to create External data source:

The specified credential cannot be found or the user does not have permission to perform this action.

This is because sys.database_scoped_credentials table is empty

thanks
Mahmood

You won't be able to insert data directly into SQL Server system tables, and you don't want to, as it's likely to corrupt the state of the database.

1 Like

thank you