Microsoft SQL Server 2017 RC Comes with Full Support for Linux

By

Finally, enterprise customers running Linux can now also run Microsoft’s SQL Server.

Microsoft loves Linux, at least in enterprise. The company has been building bridges between the two worlds by bringing Linux-centric technologies to Windows/Azure and Microsoft technologies to Linux.

Last year, Microsoft shook the world by announcing SQL Server for Linux. That was a sea-change in Microsoft’s strategy, where they clearly demonstrated that they wanted to create an even playing field for Linux.

This week, Microsoft released the first release candidate of SQL Server 2017 with full support for Linux.

“SQL Server 2017 will bring with it support for the Linux OS and containers running on Windows, Linux, and macOS. Our goal is to enable SQL Server to run in modern IT infrastructure in any public or private cloud,” Tony Petrossian, Partner Group Program Manager, Database Systems Group at Microsoft, wrote in a blog post.

According to the release notes of SQL Server 2017, SQL Server 2017 support for Linux includes the same high-availability solutions on Linux as Windows Server, including Always On availability groups integrated with Linux native clustering solutions like Pacemaker.

Some of the core features of SQL Server 2017 include the following:

  • SQL Server on Linux Active Directory integration – With RC1, SQL Server on Linux supports Active Directory Authentication, which enables domain-joined clients on either Windows or Linux to authenticate to SQL Server using their domain credentials and the Kerberos protocol. Check out the getting started instructions.
  • Transport Layer Security (TLS) to encrypt data – SQL Server on Linux can use TLS to encrypt data that is transmitted across a network between a client application and an instance of SQL Server. SQL Server on Linux supports the following TLS protocols: TLS 1.2, 1.1, and 1.0.
  • Machine Learning Services enhancements – In RC1, we add more model management capabilities for R Services on Windows Server, including External Library Management. The new release also supports Native Scoring.
  • SQL Server Analysis Services (SSAS) – In addition to the enhancements to SSAS from previous Community Technology Previews of SQL Server 2017, RC1 adds additional Dynamic Management Views, enabling dependency analysis and reporting.
  • SQL Server Integration Services (SSIS) on Linux – The preview of SQL Server Integration Services on Linux now adds support for any Unicode ODBC driver, if it follows ODBC specifications. (ANSI ODBC driver is not supported.)
  • SQL Server Integration Services (SSIS) on Windows Server – RC1 adds support for SSIS scale-out in highly available environments. Customers can now enable Always On for SSIS, setting up Windows Server failover clustering for the scale-out master.

Microsoft has also announced a new microsite for DevOps using SQL Server that serves as a platform for developers and development managers to learn how to integrate SQL Server in their DevOps tasks.

07/19/2017

Related content

  • News for Admins
    News for system administrators around the world.
  • Exploring SQL Server on Linux
    SQL Server runs on Linux now. We'll show you how Microsoft developers made their massive database system Linux ready, and we'll help you get started with setting up SQL Server on your own Linux system.
  • SMB 3.1.1 in Windows Server 2016
    We look at the new performance and security features of SMB 3.1.1 with Windows Server 2016 and Windows 10.
  • Connecting Windows Server 2016 with Azure
    Microsoft continues to integrate Windows Server with the Azure cloud. With Cloud Witness and the RDS Connection Broker, you can operate distributed environments more reliably and efficiently, and SQL databases migrate sensibly into the cloud.
  • What's new in SQL Server 2017
    Microsoft SQL Server 2017 introduces SQL Server on Linux, along with machine learning services, support for graph data, and on-premises Power BI.
comments powered by Disqus