SQL Server 2017 Release Notes

APPLIES TO: yesSQL Server (starting with 2017) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

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

Try SQL Server!

Note

SQL Server 2019 preview is now available. For more information, see What's New in SQL Server 2019.

SQL Server 2017 - general availability release (October 2017)

Database Engine

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

  • Workaround: First, reboot 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 click Properties.
    2. In the FILESTREAM tab clear Enable FILESTREAM for file I/O streaming access, then click Apply.
    3. Check Enable FILESTREAM for file I/O streaming access again with the original share name and click 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 cannot be saved. The object guid is not valid"

  • Workarounds:

Analysis Services

  • Issue and customer impact: Data connectors for the following sources are not yet avaialble 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.

horizontal_bar

SQL Server 2017 Release Candidate (RC2 - August 2017)

There are no release notes for SQL Server on Windows related to this release. See SQL Server on Linux Release notes.

horizontal_bar

SQL Server 2017 Release Candidate (RC1 - July 2017)

SQL Server Integration Services (SSIS) (RC1 - July 2017)

  • Issue and customer impact: The parameter runincluster of the stored procedure [catalog].[create_execution] is renamed to runinscaleout for consistency and readability.
  • Work around: If you have existing scripts to run packages in Scale Out, you have to change the parameter name from runincluster to runinscaleout to make the scripts work in RC1.

  • Issue and customer impact: SQL Server Management Studio (SSMS) 17.1 and earlier versions can't trigger package execution in Scale Out in RC1. The error message is: "@runincluster is not a parameter for procedure create_execution." This issue is fixed in the next release of SSMS, version 17.2. Versions 17.2 and later of SSMS support the new parameter name and package execution in Scale Out.

  • Work around: Until SSMS version 17.2 is available:
    1. Use your existing version of SSMS to generate the package execution script.
    2. Change the name of the runincluster parameter to runinscaleout in the script.
    3. Run the script.

horizontal_bar

SQL Server 2017 CTP 2.1 (May 2017)

Documentation (CTP 2.1)

  • Issue and customer impact: Documentation for SQL Server 2017 (14.x) is limited and content is included with the SQL Server 2016 (13.x) documentation set. Content in articles that is specific to SQL Server 2017 (14.x) is noted with Applies To.
  • Issue and customer impact: No offline content is available for SQL Server 2017 (14.x).

SQL Server Reporting Services (CTP 2.1)

  • Issue and customer impact: If you have both SQL Server Reporting Services and Power BI Report Server on the same machine and uninstall one of them, you cannot connect to the remaining report server with Report Server Configuration Manager.
  • Work around To work around this issue, you must perform the following operations after uninstalling one of the servers.

    1. Launch a command prompt in Administrator mode.
    2. Go to the directory where the remaining report server is installed.

      Default location for Power BI Report Server: C:\Program Files\Microsoft Power BI Report Server

      Default location for SQL Server Reporting Services: C:\Program Files\Microsoft SQL Server Reporting Services

    3. Then go to the next folder, which is either SSRS or PBIRS depending on what is remaining.

    4. Go to the WMI folder.
    5. Run the following command:

      regsvr32 /i ReportingServicesWMIProvider.dll
      

      If you see the following error, ignore it.

      The module "ReportingServicesWMIProvider.dll" was loaded but the entry-point DLLInstall was not found. Make sure that "ReportingServicesWMIProvider.dll" is a valid DLL or OCX file and then try again.
      

TSqlLanguageService.msi (CTP 2.1)

  • Issue and customer impact: After installing on a computer that has a 2016 version of TSqlLanguageService.msi installed (either through SQL Setup or as a standalone redistributable) the v13.* (SQL 2016) versions of Microsoft.SqlServer.Management.SqlParser.dll and Microsoft.SqlServer.Management.SystemMetadataProvider.dll are removed. Any application that has a dependency on the 2016 versions of those assemblies stops working and generate an error similar to: error : Could not load file or assembly 'Microsoft.SqlServer.Management.SqlParser, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

    In addition, attempts to reinstall a 2016 version of TSqlLanguageService.msi fail with the message: Installation of Microsoft SQL Server 2016 T-SQL Language Service failed because a higher version already exists on the machine.

  • Workaround To work around this issue and fix an application that depends on the v13 version of the assemblies follow these steps:

    1. Go to Add/Remove Programs
    2. Find Microsoft SQL Server 2019 T-SQL Language Service CTP2.1, right-click it, and select Uninstall.
    3. After the component is removed, repair the application that is broken or reinstall the appropriate version of TSqlLanguageService.MSI.

      This workaround removes the v14 version of those assemblies, so any applications that depend on the v14 versions will no longer function. If those assemblies are needed, then a separate installation without any side-by-side 2016 installs is required.

horizontal_bar

SQL Server 2017 CTP 2.0 (April 2017)

Documentation (CTP 2.0)

  • Issue and customer impact: Documentation for SQL Server 2017 (14.x) is limited and content is included with the SQL Server 2016 (13.x) documentation set. Content in articles that is specific to SQL Server 2017 (14.x) is noted with Applies To.
  • Issue and customer impact: No offline content is available for SQL Server 2017 (14.x).

Always On availability groups

  • Issue and customer impact: A SQL Server instance hosting an availability group secondary replica crashes if the SQL Server major version is lower than the instance that hosts the primary replica. Affects upgrades from all supported versions of SQL Server that host availability groups to SQL Server SQL Server 2017 (14.x) CTP 2.0. The issue occurs under the following conditions.
  1. User upgrades SQL Server instance hosting secondary replica in accordance with best practices.
  2. After upgrade, a failover occurs and a newly upgraded secondary becomes primary before completing upgrade for all secondary replicas in the availability group. The old primary is now a secondary, which is lower version than primary.
  3. The availability group is in an unsupported configuration and any remaining secondary replicas might be vulnerable to crash.
  • Workaround Connect to the SQL Server instance hosting the new primary replica and remove the faulty secondary replica from the configuration.

    ALTER AVAILABILITY GROUP agName REMOVE REPLICA ON NODE instanceName

    The instance of SQL Server that hosted the secondary replica recovers.

More information

info_tip Get Help

edit content Contribute SQL documentation

Did you know that you could edit the content yourself? If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.

MS_Logo_X-Small