Issue with Windows 10 Insider and SQL Server 2016 CTP 2.2

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.2 – SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available – What’s New in Master Data Services – SQL2016 CTP2.2(July) Release – 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.” –  CTP 2.2 release notes

soon. For more information,