CODEWITHSUNDEEP
sqlsql-serversql-server-2014windows-10
ispiro
ispiro

Reputation: 27633

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.)

Upvotes: 3

Views: 985

Answers (1)

Thomas Stringer
Thomas Stringer

Reputation: 5862

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.

Upvotes: 4

Related Questions