SQL Server 2017 articles, fixes and updates - Year 2017

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2017 that have been released in Year 2017. The list is daily updated.

• 316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console Q316898 KB316898 December 22, 2017
• 4052134 FIX: Errors 33111 and 3013 when backing up TDE-encrypted database in SQL Server Q4052134 KB4052134 December 12, 2017
• 4055758 FIX: Inconsistent behavior for returning trailing blanks at the end of CHAR and BINARY data in SQL Server Q4055758 KB4055758 December 6, 2017
• 4033789 FIX: A memory leak may occur when you perform Process Update operations in SSAS Q4033789 KB4033789 December 4, 2017
• 4052625 FIX: Queries that retrieve data by using non-clustered index seek take longer in SQL Server Q4052625 KB4052625 November 29, 2017
• 4046102 FIX: State of the ForceLastGoodPlan recommendation is falsely reported as Expired if applied manually in SQL Server 2017 Q4046102 KB4046102 November 29, 2017
• 4054037 FIX: Fatal error when a natively compiled stored procedure is executed to access memory-optimized tables in SQL Server 2017 Q4054037 KB4054037 November 28, 2017
• 4054036 FIX: Error 8624 when you run a query that contains a SELECT DISTINCT statement on a graph column in SQL Server 2017 on Linux or Windows Q4054036 KB4054036 November 28, 2017
• 4054035 FIX: Error 213 when you merge or split a partition of a partitioned graph table in SQL Server 2017 on Linux or Windows Q4054035 KB4054035 November 28, 2017
• 4053393 FIX: SQL Server 2017 on Linux doesn't listen to nondefault IP address specified by mssql-conf script Q4053393 KB4053393 November 28, 2017
• 4053392 FIX: Name resolution error occurs when IPv6 is disabled on startup in SQL Server 2017 on Linux Q4053392 KB4053392 November 28, 2017
• 4053386 FIX: Using ALTER TABLE on an in-memory optimized table crashes SQL Server 2017 Q4053386 KB4053386 November 28, 2017
• 4053349 FIX: "sys.external_libraries" catalog views are empty for non-dbo users in SQL Server Q4053349 KB4053349 November 28, 2017
• 4053348 FIX: External R library is installed or uninstalled repeatedly in SQL Server Q4053348 KB4053348 November 28, 2017
• 4053329 FIX: Deadlock occurs when multiple PREDICT T-SQL functions run concurrently in SQL Server 2017 Q4053329 KB4053329 November 28, 2017
• 4053291 FIX: "sys.dm_exec_query_profiles" DMV returns wrong "estimate_row_count" in SQL Server 2017 on Linux and Windows Q4053291 KB4053291 November 28, 2017
• 4052972 FIX: CT auto cleanup is stuck and not working in SQL Server 2017 Q4052972 KB4052972 November 28, 2017
• 4052697 FIX: TLS cipher suites with PFS don't work for secure connections in SQL Server 2017 on Linux Q4052697 KB4052697 November 28, 2017
• 4052338 FIX: Excessive PREMPTIVE_OS_CREATEDIRECTORY waits during workload that compiles or recompiles memory-optimized tables or table types Q4052338 KB4052338 November 28, 2017
• 4052126 Update adds new "marked_transaction_latch_trace" extended event in SQL Server 2017 on Linux and Windows Q4052126 KB4052126 November 28, 2017
• 4052122 Performance improvement for Spatial Internal Filter in SQL Server 2017 Q4052122 KB4052122 November 28, 2017
• 4046056 FIX: Assertion occurs when you access memory-optimized table through MARS in SQL Server 2016 and 2017 Q4046056 KB4046056 November 28, 2017
• 4045814 FIX: "Message 611" error when you use BULK INSERT or INSERT SELECT to insert data into a clustered columnstore index Q4045814 KB4045814 November 28, 2017
• 4043947 FIX: Bookmarks functionality does not work completely when you open a report in MHTML format through Outlook in SSRS Q4043947 KB4043947 November 28, 2017
• 4042962 FIX: "An unknown error" for "Show More Members" on Entity Dependencies explorer page in SQL Server 2016 and 2017 Master Data Services Q4042962 KB4042962 November 28, 2017
• 4042232 FIX: Access violation when you cancel a pending query if the missing indexes feature is enabled in SQL Server Q4042232 KB4042232 November 28, 2017
• 4039592 FIX: Cannot change the password for a SQL Server service account when additional LSA protection is enabled Q4039592 KB4039592 November 28, 2017
• 4035062 FIX: Memory use with many databases greater in SQL Server 2016 than earlier versions Q4035062 KB4035062 November 28, 2017
• 4040512 FIX: Error when exporting a Reporting Services report to PDF in SQL Server 2016 or 2017 Q4040512 KB4040512 November 22, 2017
• 4040401 FIX: Access violation for spatial datatypes query via linked server in SQL Server Q4040401 KB4040401 November 22, 2017
• 4040376 FIX: Managed Backup to Microsoft Azure stops after large database backup in SQL Server Q4040376 KB4040376 November 22, 2017
• 4039511 FIX: Managed Backup fails intermittently because of SQLVDI error in SQL Server Q4039511 KB4039511 November 22, 2017
• 4039510 FIX: Access violation occurs when you use sp_xml_preparedocument to open XML documents in SQL Server Q4039510 KB4039510 November 22, 2017
• 4039509 FIX: SSAS crashes when you process an SSAS database or cube in SQL Server Q4039509 KB4039509 November 22, 2017
• 4038882 FIX: SQL Server Managed Backup does not delete old backups that are beyond the retention period in SQL Server Q4038882 KB4038882 November 22, 2017
• 4034789 FIX: An unexpected exception error occurs when a XIRR measure processes too many records in SSAS 2016 or 2017 Q4034789 KB4034789 November 22, 2017
• 4019840 FIX: Queries against PolyBase external tables return duplicate rows in SQL Server 2016 and 2017 Q4019840 KB4019840 November 22, 2017
• 3208545 FIX: SQL Server 2016 or 2017 Analysis Services may crash in a specific situation Q3208545 KB3208545 November 22, 2017
• 4052938 FIX: DST changes of Sao Paulo time zone are not determined by SQL Server 2017 on Linux Q4052938 KB4052938 November 15, 2017
• 4046638 Add the ability to disable or enable a few new DMVs and DMFs introduced in SQL Server 2017 Q4046638 KB4046638 November 8, 2017
• 4039284 Enhancement: New keyword is added to CREATE and UPDATE STATISTICS statements to persist sampling rate for future statistics updates in SQL Server Q4039284 KB4039284 October 31, 2017
• 4043455 FIX: Portability and performance differ between Windows and Linux scheduler mappings in SQL Server 2017 Q4043455 KB4043455 October 26, 2017
• 4046099 FIX: Assertion error after creating snapshot backup for database with memory-optimized tables in SQL Server 2017 Q4046099 KB4046099 October 25, 2017
• 4046066 All transactions reported as completed even though some fail while trying to commit in SQL Server 2017 Q4046066 KB4046066 October 25, 2017
• 4046055 FIX: FORCE_LAST_GOOD_PLAN recommendation stuck at "Verifying" at first verification in SQL Server 2017 Q4046055 KB4046055 October 25, 2017
• 4032543 FIX: SSAS crashes when you run a DAX or MDX query in SSAS in Tabular mode Q4032543 KB4032543 October 25, 2017
• 4025402 FIX: Security Bulletin MS16-136 breaks the SSRS data source type in PowerPivot in SQL Server 2017 and SQL Server 2016 Q4025402 KB4025402 October 25, 2017
• 4022753 FIX: SSAS crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy Q4022753 KB4022753 October 25, 2017
• 4046801 “Cannot apply value 'null' to property ServerInstance" error when looking at subscription properties in SQL Server 2017 or 2016 Q4046801 KB4046801 October 24, 2017
• 4046744 FIX: DML statements that use cascading operations fail in SQL Server 2017 Q4046744 KB4046744 October 24, 2017
• 4046065 FIX: Memory corruption occurs during Availability Group failovers for DTC transactions in SQL Server 2017 Q4046065 KB4046065 October 24, 2017
• 4046044 FIX: Unable to install SQL Server 2017 when instance name/ID/installation path contains multi-byte characters Q4046044 KB4046044 October 24, 2017
• 4046022 FIX: Automatic Tuning settings cannot be configured on ModelDB in SQL Server 2017 Q4046022 KB4046022 October 24, 2017
• 4045687 Update to enable SQL Server 2017 Express edition to act as a witness role in a database mirroring session Q4045687 KB4045687 October 24, 2017
• 4045678 FIX: Unexpected error when you use the DReplay feature to replay a captured trace in SQL Server 2017 Q4045678 KB4045678 October 24, 2017
• 4044009 FIX: A deadlock condition occurs when you create a new database in SQL Server 2017 Q4044009 KB4044009 October 24, 2017
• 4043478 FIX: Error when you export an SSRS report on an iOS device in SQL Server 2016 or 2017 Q4043478 KB4043478 October 24, 2017
• 4043459 FIX: Remote instance of SQL Server crashes when a stored procedure bulk loads an incomplete data file into a temporary table Q4043459 KB4043459 October 24, 2017
• 4043103 FIX: Load data from staging tables takes a much longer time to finish when recursive hierarchy is used in Master Data Services Q4043103 KB4043103 October 24, 2017
• 4042885 FIX: Divide-by-zero error when a parallel query is forced to run in serial mode in SQL Server 2017 Q4042885 KB4042885 October 24, 2017
• 4042251 FIX: Database mirroring failover fails with error 3456 in SQL Server 2016 or 2017 Q4042251 KB4042251 October 24, 2017
• 4041553 SQL Server Service Packs are discontinued starting from SQL Server 2017 Q4041553 KB4041553 October 24, 2017
• 4040535 FIX: SQL Server Managed Backups do not run a scheduled log backup in SQL Server 2016 or 2017 Q4040535 KB4040535 October 24, 2017
• 4040530 FIX: Log chain break in the "managed_backup.fn_available_backups" table in SQL Server 2016 or 2017 Q4040530 KB4040530 October 24, 2017
• 4040519 FIX: Automatic seeding in Availability Groups randomly causes error 41169 in SQL Server 2016 or 2017 Q4040519 KB4040519 October 24, 2017
• 4040085 FIX: "Ambiguous paths" error when deploying tabular model database to Analysis Services in SQL Server 2016 or 2017 Q4040085 KB4040085 October 24, 2017
• 4039868 FIX: Performance drop when using In-Memory OLTP with Always On availability groups in SQL Server 2016 or 2017 Q4039868 KB4039868 October 24, 2017
• 4039776 FIX: Incorrect behavior when you use memory-optimized tables with "where exists" statement in SQL Server 2016 or 2017 Q4039776 KB4039776 October 24, 2017
• 4039736 FIX: SSIS package does not start when it's run by a CLR stored procedure whose user does not have SYSADMIN permissions Q4039736 KB4039736 October 24, 2017
• 4039126 FIX: Horizontal scroll bar missing from Subscription page in SSRS 2016 or 2017 web portal Q4039126 KB4039126 October 24, 2017
• 4039125 FIX: "The folder ... does not exist" error when deleting a folder in web portal of SQL Server 2016 or 2017 Reporting Service Q4039125 KB4039125 October 24, 2017
• 4039124 FIX: Memory spike in LSASS.EXE when you enable Basic Authentication mode in SSRS 2016 or 2017 Q4039124 KB4039124 October 24, 2017
• 4025020 FIX: SUSER_SNAME function returns different results between SQL Server 2014 and SQL Server 2016 or 2017 Q4025020 KB4025020 October 24, 2017
• 4024860 Update to improve the performance for columnstore dynamic management views "column_store_row_groups" and "dm_db_column_store_row_group_physical_stats" in SQL Server 2016 or 2017 Q4024860 KB4024860 October 24, 2017
• 4023995 FIX: A data mask on a floating points column is not applied in SQL Server 2017 and SQL Server 2016 Q4023995 KB4023995 October 24, 2017
• 4023865 FIX: Expanding the Entities folder on the Manage Groups page takes a long time in SQL Server MDS Q4023865 KB4023865 October 24, 2017
• 4022895 FIX: Excel crashes when you save a workbook as a PDF file by using the Adobe Acrobat PDFMaker add-in if the MDS add-in for Excel in SQL Server is also installed Q4022895 KB4022895 October 24, 2017
• 4022594 FIX: Incorrect MDX query results if a table cross join is run on a table hierarchy member in SSAS Q4022594 KB4022594 October 24, 2017
• 4021994 FIX: SSAS crashes when a measure is added that refers to null values in Power BI Q4021994 KB4021994 October 24, 2017
• 4018908 FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model) Q4018908 KB4018908 October 24, 2017
• 4017827 FIX: Reporting Services "SortExpression" cause rsComparisonError when there is a NULL value in a column set as "DataTimeOffset" Q4017827 KB4017827 October 24, 2017
• 3212541 FIX: SSAS crashes when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase Q3212541 KB3212541 October 24, 2017
• 4033835 Access violations and memory dump files when you use XEvent session with sqlos.wait_info event in SQL Server Q4033835 KB4033835 October 9, 2017
• 3212023 Performance degradation when you upgrade from database compatibility level 120 to 130 in SQL Server 2016 or in SQL Server 2017 on Windows Q3212023 KB3212023 October 9, 2017
• 3204545 The .NET Framework 4.6.2 client driver for "Always Encrypted" intermittently fails during row decryption Q3204545 KB3204545 October 9, 2017
• 3200464 Error when you attach a CDC-enabled database to an instance of SQL Server 2016 or SQL Server 2017 on Windows Q3200464 KB3200464 October 9, 2017
• 3196535 Description of the Update Cache folder in SQL Server Q3196535 KB3196535 October 9, 2017
• 3195161 Defragmenting SQL Server database disk drives Q3195161 KB3195161 October 9, 2017
• 3191316 Words that have leading decimal points are not returned by an English word breaker in SQL Server Q3191316 KB3191316 October 9, 2017
• 3189675 Join containment assumption in the New Cardinality Estimator degrades query performance in SQL Server 2014 and later Q3189675 KB3189675 October 9, 2017
• 3180087 Poor performance when you run INSERT.. SELECT operations in SQL Server 2016 or SQL Server 2017 on Windows Q3180087 KB3180087 October 9, 2017
• 3163368 Max_Queue_Readers property is ignored when you try to limit activation tasks in Service Broker Q3163368 KB3163368 October 9, 2017
• 3108695 Client connectivity issues because of changes in name resolution in SQL Server 2014 or later Q3108695 KB3108695 October 9, 2017
• 3092936 Increased CPU usage when you access a SQL Server FileTable share from Windows Explorer Q3092936 KB3092936 October 9, 2017
• 2871474 SQL Transaction log grows when you use Change Data Capture for Oracle by Attunity Q2871474 KB2871474 October 9, 2017
• 2754171 Controlling Autostat (AUTO_UPDATE_STATISTICS) behavior in SQL Server Q2754171 KB2754171 October 9, 2017
• 918992 How to transfer logins and passwords between instances of SQL Server Q918992 KB918992 October 9, 2017
• 819546 SQL Server support for mounted volumes Q819546 KB819546 October 9, 2017
• 307864 Error message when you connect to an instance of SQL Server: "Cannot open user default database" Q307864 KB307864 October 9, 2017
• 307487 How to shrink the tempdb database in SQL Server Q307487 KB307487 October 9, 2017
• 231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem Q231619 KB231619 October 9, 2017
• 224071 Troubleshooting SQL Server backup and restore operations Q224071 KB224071 October 9, 2017