Clever Geek Handbook

SQL Server Configuration Manager - Cannot View Startup Mode Dropdown

I have a fresh installation of Windows 10 with SQL Server Express 2014 installed. The dropdown menu for changing the startup mode is not showing correctly:

snip

How do I get around / fix this? How do I change the startup mode?

(I already rebooted my computer.)

+3


source to share


1 answer


I faced this problem several times. This is some kind of weirdness with the 64-bit version of SQL Server Configuration Manager.



The solution here is to explicitly use the 32-bit version of SSCM by navigating to "C: \ Windows \ SysWOW64 \ SQLServerManager12.msc". Use this version and you should be able to see the options drop down.

+4


source






More articles:


All Articles