Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Windows 8.1 Upgrade And SQL Server Configuration Manager

  • 19 January 2014
  • Author: CraigLove
  • Number of views: 17401

After some hesitation I installed Windows 8.1 on my main laptop.  I am familiar with the new interface and so there were no surprises in that regard.  However, I was quite fond of Windows 7 and it had never failed me. 

Why then?  Well, there were a few reasons but the main reason is that I wanted to move from Virtual Box to Hyper-V.  So far, my upgrade experience has been very, very good.  I was amazed at how well the laptop configurations migrated!  Naturally, there are a few potential of which you should be aware.  Here are a few of pointers for you who are considering the upgrade path. 

Note, I am no expert on the different upgrade paths.  There may be better (and worse) paths.  My installation set upgraded my Windows 7 all the way to Windows 8.1.

  • The upgrade files did not even attempt to keep the applications that were already installed.  Be prepared to reinstall.
  • The installation process asked if I wanted to keep the user files.  YES!  Note- it does not keep any files that are not in the user folders.  All files that are not in the user folders will be lost unless you have backed them up somewhere.  It is far simpler to move these files into your user folders and then move them back after the upgrade. 
  • Be prepared to reassign rights to some of the folders.  I encountered this a couple of times with some of the non-user folder file sets.  You may need to take ownership of the root folders and also grant minimal privileges to the everyone.
  • And finally, after installing SQL Server 2012, I was not able to find the launch icon for the SQL Server 2012 Configuration manager.  What a pain!  It seems that this is common.  The simplest fix is to create your own shortcut on the desktop.  From there you can decide if you want to pin it to the Start screen.  Here is the shortcut you can use to recreate the link:

 C:\Windows\SysWOW64\mmc.exe /32 C:\Windows\SysWOW64\SQLServerManager11.msc

All in all I am very pleased with the new OS.  I have had a solid weak of intensive consulting with the “new” laptop and it has not failed me!


Categories: Analysis Services
Rate this article:
No rating


Other posts by CraigLove

Please login or register to post comments.