Problem with setting up DB sharding

At this moment I'm following this tutorial: https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-query-getting-started/

But when I use this code: 

CREATE EXTERNAL DATA SOURCE MyElasticDBQueryDataSrc WITH (TYPE = SHARD_MAP_MANAGER, LOCATION = '<used_my_server_name_here>.database.windows.net', DATABASE_NAME = 'ElasticScaleStarterKit_ShardMapManagerDb', CREDENTIAL = ElasticDBQueryCred, SHARD_MAP_NAME = 'CustomerIDShardMap' ) ;

I get the following error message:

Msg 102, Level 15, State 1, Line 8
Incorrect syntax near 'EXTERNAL'.

At the moment I'm using the latest version of the SQL 2014 management studio:

Microsoft SQL Server Management Studio 12.0.4416.0
Microsoft Analysis Services Client Tools 12.0.4416.0
Microsoft Data Access Components (MDAC) 6.3.9600.16384
Microsoft MSXML 3.0 5.0 6.0 
Microsoft Internet Explorer 9.11.9600.16384
Microsoft .NET Framework         4.0.30319.34003
Operating System 6.3.9600

Does anyone know how to solve this? 

July 27th, 2015 8:16am

Hi Jos,

Thanks for reporting this issue. Were you able to successfully create your master key and your credential as described in the tutorial? We had new syntax for credential creation getting deployed over the weekend. But, if the master key and the credential were created successfully then you are facing a different issue.

We were trying to repro your situation here, but could not. Could you let us know which region you created your SQL DB server in - and the name of your server? That will help us to either repro or find out from the logs what's happening. You can send the information via email to torsteng(at)microsoft(dot)com.

Thanks,

Torsten

Free Windows Admin Tool Kit Click here and download it now
July 27th, 2015 12:47pm

Hi Jos,

Please check your DB edition. Currently Elastic DB Query is enabled only on Premium DBs. We are looking at supporting it on other service tiers soon.

July 28th, 2015 12:16pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics