Issue with Windows 10 Insider and SQL Server 2016 CTP 2.2Posted: August 10, 2015 Filed under: Microsoft Server SQL Server 2016, Windows 10 | Tags: Microsoft SQL Server 2016, Windows 10 Leave a comment
With Windows 10 Insider and SQL Server 2016 CTP 2.2, do not just use your Windows Insider Account when installing SQL Server.
This may appear to work however it will break when using Replication!
Fixed by using a local account however there are more gotchas
SQL Server 2016 CTP 2.2Posted: July 24, 2015 Filed under: Microsoft Server SQL Server 2016 | Tags: Microsoft SQL Server 2016 Leave a comment
http://blogs.technet.com/b/dataplatforminsider/archive/2015/07/22/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available.aspx – SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available
http://blogs.msdn.com/b/mds/archive/2015/07/23/what-s-new-in-master-data-services-sql2016-ctp2-2-july-release.aspx – What’s New in Master Data Services – SQL2016 CTP2.2(July) Release
http://sqlserver-qa.net/2015/07/23/sql-server-2016-community-technology-preview-2-2/ – CTP2 will also have improvements to the Query Store, Query Execution, DBCC CHECKCB performance, and Temporal Database.
“There is an issue with the SQL Server 2016 CTP 2.2 release that causes downtime during rolling upgrades across an AlwaysOn Availability Group. If you are not using AlwaysOn, you will not experience the issue. We recommend that AlwaysOn users not upgrade to CTP 2.2 at this time. A replacement build of SQL Server 2016 CTP 2.2 is in process and will be available.”
http://go.microsoft.com/fwlink/?LinkID=398124 – CTP 2.2 release notes
soon. For more information,