Estoy intentando hacer consultas entre base de datos.
Utilizando el siguiente proyecto:
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-get-started
Al momento de querer consultar la tabla externa me marca lo siguiente:
Error accessing the shard map manager database. Please verify that the shard map manager database is available. If it is available, please verify that the definition and affiliated credential are correct for external data source Remote_ElasticScaleStarterKIT_Shard0.
Script estando desde SharMapManegerDb
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'passwordPrueba';
CREATE DATABASE SCOPED CREDENTIAL user_login
WITH IDENTITY = 'identityPrueba', SECRET = 'secretPrueba'
CREATE EXTERNAL DATA SOURCE Remote_ElasticScaleStarterKIT_Shard0
WITH
(
TYPE=SHARD_MAP_MANAGER,
LOCATION='name.database.windows.net',
DATABASE_NAME='ElasticScaleStarterKIT_Shard0',
CREDENTIAL= user_login,
SHARD_MAP_NAME='ShardMap'
);
CREATE EXTERNAL TABLE [dbo].[order_line](
[CustomerId] [int] NOT NULL,
[OrderId] [int] IDENTITY(1,1) NOT NULL,
[OrderDate] [datetime] NOT NULL,
[ProductId] [int] NOT NULL,
)
WITH
(
DATA_SOURCE = Remote_ElasticScaleStarterKIT_Shard0,
SCHEMA_NAME = 'dbo',
OBJECT_NAME = 'Orders',
DISTRIBUTION=ROUND_ROBIN
);
Al ejecutar la siguiente linea marca el error
select * from dbo.[order_line]