Problem with Azure PlayCloud Labs course (How to Launch an Azure SQL database)

[Vasilii Tsyganenko]

Hi all,

I have a problem in Azure PlayCloud Labs course, in guided Lab: “How to Launch an Azure SQL database”.

Whenever I follow lab instruction, I always getting following error:

Resource ‘vts-sql-svr’ was disallowed by policy. (Code: RequestDisallowedByPolicy, Policy(s): database-restriction-azure-lab-rg-XrEhZGQYVJGa

I checked 3 times to make sure all the fields are filled according provided instruction, however, I am still receiving the same error.

Please see below for my setup:

===================================================================

Basics

===================================================================

Subscription Azure Labs Subscription

Resource group azure-lab-rg-XrEhZGQYVJGa

Region Central US

Database name vts-sql-svr

Server (new) vts-sql-demo

Authentication method SQL authentication

Server admin login vts

Compute + storage General Purpose – Serverless: Standard-series (Gen5), 1 vCore, 32 GB storage, zone redundant disabled

Backup storage redundancy Locally-redundant backup storage

===================================================================

Networking

===================================================================

Allow Azure services and resources to access this server No

Private endpoint None

Minimum TLS version 1.2

Connection Policy Default

===================================================================

Security

===================================================================

Identity Not enabled

Transparent data encryption (Server level) Service-managed key selected

Database level customer-managed key Not configured

Database level user assigned managed identity Not configured

Advanced data security Not now

Always Encrypted with secure enclaves Not configured

Sql Ledger(Database) Disabled

Digest Storage Disabled

===================================================================

Additional settings

===================================================================

Use existing data Blank

Collation SQL_Latin1_General_CP1_CI_AS

Maintenance window System default (5pm to 8am)

===================================================================

Tags

===================================================================

Any ideas what’s wrong?

[JR-TutorialsDojo]

Hello Vasilii Tsyganenko,

Thanks for reaching out to us.

We’ll check this on our end and will get back to you as soon as possible.

Regards,
JR @ Tutorials Dojo

[JR-TutorialsDojo]

Hello Vasilii Tsyganenko,

You’re seeing that error because step 6 under Launching an Azure SQL Database wasn’t followed. The Compute + Storage service tier should be set to Basic.

Please update the configuration and try again. Let me know if the issue persists. I’ll be glad to assist further.

Best regards,
JR @ Tutorials Dojo