SQL Server 2017 release notes

Applies to: SQL Server 2017 (14.x) and later

This article describes limitations and issues with SQL Server 2017. For related information, see:

• What's new in SQL Server 2017
• Release notes for SQL Server 2017 on Linux
• SQL Server 2017 Cumulative updates for information about the latest cumulative update (CU) release

Try SQL Server

Download SQL Server 2017

Spin up a Virtual Machine with SQL Server 2017

Note

SQL Server 2022 (16.x) is available. For more information, see What's new in SQL Server 2022.

General availability release (October 2017)

Database Engine

• Issue and customer impact: After upgrade, the existing FILESTREAM network share might be no longer available.

• Workaround: First, restart the computer and check if the FILESTREAM network share is available. If the share is still not available, complete the following steps:

  1. In SQL Server Configuration Manager, right-click the SQL Server instance, and select Properties.
  2. In the FILESTREAM tab clear Enable FILESTREAM for file I/O streaming access, then select Apply.
  3. Check Enable FILESTREAM for file I/O streaming access again with the original share name and select Apply.

Master Data Services (MDS)

• Issue and customer impact:

  On the user permissions page, when granting permission to the root level in the entity tree view, you see the following error: "The model permission can't be saved. The object guid isn't valid"

• Workaround:

  • Grant permission on the sub nodes in the tree view instead of the root level.

Analysis Services

• Issue and customer impact: Data connectors for the following sources aren't yet available for tabular models at the 1400 compatibility level.

  • Amazon Redshift
  • IBM Netezza
  • Impala

• Workaround: None.

• Issue and customer impact: Direct Query models at the 1400 compatibility level with perspectives can fail on querying or discovering metadata.

• Workaround: Remove perspectives and redeploy.

Tools

• Issue and customer impact: Running DReplay fails with the following message:

  Error DReplay Unexpected error occurred!
  

• Workaround: None.

More information

• SQL Server Reporting Services release notes.
• Known Issues for Machine Learning Services
• SQL Server Update Center - links and information for all supported versions

Get help

• Ideas for SQL: Have suggestions for improving SQL Server?
• Microsoft Q & A (SQL Server)
• DBA Stack Exchange (tag sql-server): Ask SQL Server questions
• Stack Overflow (tag sql-server): Answers to SQL development questions
• Reddit: General discussion about SQL Server
• Microsoft SQL Server License Terms and Information
• Support options for business users
• Additional SQL Server help and feedback

Contribute to SQL documentation

Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page.

For more information, see How to contribute to SQL Server documentation