This article helps you to determine whether your SQL Server database runs on Microsoft Azure.
Instructions
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”.
Azure-specific Query
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: