TLS 1.0/1.1 Deprecation FAQ – Schoolzilla Pro

Why are we making this change?

TLS 1.0/1.1 are older security protocols that allowed customers to securely access the Schoolzilla SQL Server database. Since then, more secure protocols have been developed to ensure that data stays safe when in transit from our servers. Because of the greatly enhanced security in newer protocols, and to ensure all data remains secure, TLS 1.0/1.1 have been deprecated on our SQL Servers (as of August 2021).

What is required to connect to your Schoolzilla Data Warehouse?

In many cases, no changes are required. If you are using current versions of Microsoft Windows and SQL Server Management Studio, Mac OS and Azure Data Studio, or Tableau, you should not be affected by this change.

If you are not running current versions of this software, you may need to update your system to utilize newer security protocols.

Client Software	Resolution
Azure Data Studio	Ensure you are running a current version of Azure Data Studio
SQL Management Studio (SSMS)	Ensure you have all the required patches to enable TLS 1.2 Support on your client machine - TLS 1.2 Support for SQL Server Ensure you are running a current version of SSMS
Tableau Online	N/A (Should not be affected)
Tableau Desktop / Server	Ensure TLS 1.2 and higher are enabled for Tableau Server - Tableau Security Hardening Guide Ensure that you are not running the FreeTDS ODBC driver (For Tableau on Linux) and instead are using the Microsoft-provided ODBC driver - Tableau Community Post Tableau drivers

If you still experience issues connecting to your Schoolzilla data warehouse or have other questions, please reach out to Support.