Issue with Windows 10 Insider and SQL Server 2016 CTP 2.2

Posted: August 10, 2015 | Author: | Filed under: Microsoft Server SQL Server 2016, Windows 10 | Tags: , | 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!

http://www.smooth1.co.uk/mssql/repl_guide1/index.html

Fixed by using a local account however there are more gotchas

http://www.smooth1.co.uk/mssql/repl_guide2/index.html

Advertisement

SQL Server 2016 CTP 2.2

Posted: July 24, 2015 | Author: | Filed under: Microsoft Server SQL Server 2016 | Tags: | 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,