Why does sql configuration manager show 32 and 64 bit options when only 64 bit version is installed?

All we need is an easy explanation of the problem, so here it is.

I have installed sql server 64 bit.

Why does sql configuration manager show 32 and 64 bit options when only 64 bit version is installed?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

Because you could potentially have some old 32 bit instance on that computer. The config manager tool is designed to allow you to configure instance of that version and lower.

One could argue that the tool shouldn’t show that node if there isn’t any 32 bit instances on that computer, but that would be a wish for MS to do: https://feedback.azure.com/forums/908035-sql-server

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply