difference between azure sql database and azure database server

Question

Hello There,

Can anyone please explain me difference between (Azure) single database and (azure) database server in Azure-sql creation (please the attached screenshot).

My objective is to maintain adventureworksdw in azure, access it from SSAS-Tabular Mode; to achieve do I just have create a single database or database server?

Answer 1

Hi @ArunRaaman ,

Welcome to Microsoft Q&A!

Base on my research, this is a Azure issue, not SSAS issue. You could refer to this thread, see below:

Database Server runs your databases. You can't create "Single Database" without a server.
You pay only for databases/elastic pools, but you manage them through database server.
One server can host many databases.
Database Server is free and is mostly a logical/management tool, something like a "Resource Group".

And also you could get more details from below reference:
What is a single database in Azure SQL Database?

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.