Azure SQL Server version and upgrade TLS to 1.2

Question

Hello,

We have SQL servers and want to upgrade TLS to 1.2.

I queried the version of SQL DB and got 12.0.2000.8 (2014 RTM).

It looks this version isn't support TLS 1.2.

I'd like to know

1. How to verify our SQL server as a PaaS or SQL Server on VM?
2. If it's SQL Server on VM how to upgrade SQL server to the latest version?
3. Can we upgrade TLS to 1.2 of current version of SQL server?

Thanks,

Eunsu

Answer 1

That version number certainly sounds like Azure SQL Database.

If you connect to something.database.windows.net, that is Azure SQL Database.

You can also run this query:

SELECT serverproperty('Edition'), serverproperty('EngineEdition')

The output would be "SQL Azure" and 5 for Azure SQL Database.

And, yes, Azure SQL Database supports TLS 1.2.