Issue when installing SQL Server 2016 management tools using the Administrator account in Windows Server 2016 Technical Preview
Posted: (EET/GMT+2)
Now that SQL Server 2016 has gone gold, I wanted to try installing it to the latest Windows Server 2016 technical preview version. In SQL Server 2016, the installation of the database engine is now separated from the (graphical) management tools, so you cannot install both in a single shot anymore.
This leads to a slight problem: if you have logged in to Windows Server 2016 as the default Administrator (which is initially the only account you can use), then with the default settings of the server, you cannot install the SQL management tools, because the default web browser, Edge, cannot be started using the built-in Administrator account.
If you try to launch the Edge browser in Windows Server 2016 Preview when logged in as the local Administrator, you will get the following error message:
This app can’t open Microsoft Edge can’t be opened using the Built-in Administrator account. Sign in with a different account and try again.
Since Edge is the default browser, the link in SQL Server 2016's installer that opens the web page to download and install the management tools (SSMS), does not work.
Luckily, there's a very simple workaround: just start Internet Explorer instead, and go to this URL (which is the one the SQL Server installer tries to open):
https://msdn.microsoft.com/en-us/library/mt238290.aspx
Of course, nothing stops you from accessing this URL from an another machine as well, and downloading the management tools from there.
Two other alternative solutions: change the default browser in Windows to something else, and try again. Secondly, simply obey the instructions given, log in using another account, and install the SQL Server Management Studio using that account.
Problem solved!