Friday, May 29, 2015

Workaround for the SQL Server 2016 CTP2 installation error

The installation is fully documented here and here.

It was noted previously that the installation did not succeed and several errors were flagged.

Looking at the errors it appears that the installation wizard may not have retrieved the username for Windows Autheenticaiton which it does automatically through the interactive windows assosiated with User/Group.

However looking around a workaround was found which seems to indicate that the SQL Server Installation Center program may have other bugs since installation did not succeed.

In the Services page of Control Panel the property of the SQL Server 2016 was changed to this. The original Log on as; was, This account with( .\Jayaram) and masked passwords.


This required stopping the server and starting again. When the server started the SQL Server Management Studio 2016 did not have any problem in connecting to the server with the same credentials (Hodentek8/Jayaram) displayed in the Connect to Server window.
The next picture shows Object Browser in the SQL Server Maangement Studio 2016.


Details of SQL Server 2016 Version installation


PowerShell Pro Tools is a Visual Studio Community 2017 extension that you can try free

I see there is at least one extension, PowerShell Pro Tools that you can download. You can find it in the Visual Studio Community 2017...