Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the spinupwp domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /sites/coreysalzano.com/files/wp-includes/functions.php on line 6121
Azure External Tables: Please verify that the shards are accessible – Corey Salzano

Corey Salzano

Azure External Tables: Please verify that the shards are accessible

Are you getting this error from Azure SQL Server? Login failed on ServerName.database.windows.net.DatabaseName Please verify that the shards are accessible and that the credential information affiliated with external data source ExternalDataSourceName is correct.

When I ran into this error while migrating a SQL Server instance to Azure and designing External Tables, it was because the user I specified as the IDENTITY during DATABASE SCOPED CREDENTIAL creation had a different password that the LOGIN of the same name in the Master database.

Say we create a user in the Master database like this: 

CREATE LOGIN ExternalTableAdministrator WITH PASSWORD = 'Nr26MY4@Q407inLE83[I7L$~5j5UL';

Later, when creating a database-scoped credential (and specifying this user as the identity), make sure to use the same password:

CREATE DATABASE SCOPED CREDENTIAL [ExternalTableCred]
    WITH IDENTITY = 'ExternalTableAdministrator',
    SECRET = 'Nr26MY4@Q407inLE83[I7L$~5j5UL';
GO

Comments

One response to “Azure External Tables: Please verify that the shards are accessible”

  1. Jan

    Thanks Correy,
    Although I have created these database scoped credentials before, I couldn’t figure out why I was not able to access the external tables.
    Thanks to your post I found a very silly typo when copying the password of the login to the credential.