Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server 2017 (14.x) and later
This article describes limitations and issues with SQL Server 2017. For related information, see:
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.
Issue and customer impact: After upgrade, the existing FILESTREAM network share may 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:
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"
Workaround:
Issue and customer impact: Data connectors for the following sources are not yet available for tabular models at the 1400 compatibility level.
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.
There are no release notes for SQL Server on Windows related to this release. See SQL Server on Linux Release notes.
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:
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.
Launch a command prompt in Administrator mode.
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
Then go to the next folder, which is either SSRS or PBIRS depending on what is remaining.
Go to the WMI folder.
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.
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:
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.
- User upgrades SQL Server instance hosting secondary replica in accordance with best practices.
- 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.
- 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 that hosts 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.
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
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayTraining
Module
Introduction to SQL Server 2022 T-SQL enhancements - Training
SQL Server 2022 introduces a range of new features and enhancements, providing powerful tools and capabilities that optimize performance and offer better control on SQL objects manipulation and creation.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.