This article helps you to determine whether your SQL Server database runs on Microsoft Azure.
Follow the steps listed below to determine whether your database runs on Azure. An Azure-based SQL Server database can be recognized based upon:
- Name of the database server ends on database.windows.net.
- Response to a specific query.
Name of Database Server
An Azure SQL Server database is typically recognized by checking the host name used to connect like in the picture below:
On Power BI it looks like this:
Your SQL Server instance runs on Azure when the host name ends on “.database.windows.net”.
You can also execute the following query to supplement your investigation:
select * from sys.database_service_objectives
The query will return your service tier on Azure databases like in:
An error will be returned on non-Azure SQL Server environments: