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
CODE

The query will return your service tier on Azure databases like in:

An error will be returned on non-Azure SQL Server environments: