Tuesday, March 15, 2016

SQL Server Configuration Manager Missing After Windows Server 2012 Upgraded to 2012 R2

Tuesday, March 15, 2016

I had this issue after I upgraded the operating system from Windows Server 2012 to 2012 R2. The SQL Server 2012 on the same server worked fine until I needed to access to SQL Server Configuration Manager for troubleshooting on some issue related to using SCCM 2012. That was when I realized SQL Server Configuration Manager was now missing.

The solution for the issue is as below:
1. On a SQL server running the same version of SQL Server (2012 SP1) and installation features, I opened the folder C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2012; (please take note that this is hidden folder)

2. Copied the folder Configuration Tools to the same folder on the SQL Server with the missing link to SQL Server Configuration Manager.

Reference: http://thoughtsonopsmgr.blogspot.my/2014/01/quick-trick-where-is-sql-server.html

0 comments:

Post a Comment

 
@Chiq & Stuff © 2008. Design by Pocket