question

$$ANON_USER$$ avatar image
0 Votes"
$$ANON_USER$$ asked NavtejSaini-MSFT commented

SQL Azure Error accessing the shard map manager database

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]

azure-sql-database
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

anonymous user We are checking this and will get back to you

0 Votes 0 ·

anonymous user

Can you please convey if you created the pool from Single instance or the Elastic pool was directly created?

Regards
Navtej S

0 Votes 0 ·

0 Answers