Search code examples
sqlsql-serversql-server-2014windows-10

SQL Server Configuration Manager - Can't view Start-Mode drop-down


I have a new Windows 10 installation with SQL Server Express 2014 installed. The drop-down menu for changing the start mode doesn't show correctly:

snip

How do I circumvent / fix this? How do I change the start mode?

(I've already restarted the computer.)


Solution

  • I have run into this issue a few times. It's some sort of oddity 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 that version and you should be able to see the drop down options.