"'System' is not a valid database edition in this version of SQL Server. is the error I received when trying to add existing databases to my SQL elastic pool

Question

Add existing databases to the elastic pool

Upon successfully completing deployment of your resources, select Go to resource. Your SQL elastic pool pane appears on the Overview section. Note there are currently no databases in the pool.

In the top menu bar, select Configure. The Configure pane appears for your SQL elastic pool.

Select the Databases tab, and then select Add databases. The Add databases pane appears.

Select the databases you created for both locations, then select Apply. The Configure pane reappears.

1. In the top menu bar, select Save.

Error MSG:

'System' is not a valid database edition in this version of SQL Server. (Code: ProvisioningDisabled)

Answer 1

Make sure you are following the steps correctly. Read this article with images that can guide you better.

As a workaround, try adding the existing Azure SQL database (not a SQL Server instance/database) to the elastic pool using T-SQL. Connect to the master database on the Azure SQL logical server and run below statement:

ALTER DATABASE db1   
MODIFY ( SERVICE_OBJECTIVE = ELASTIC_POOL ( name = pool1 ) ) ; 

Make sure you are also adding a DTU database on an elastic pool for DTU databases and add vCore databases to elastic pools intended for vCode model.