Install SQL Server 2008 32 bit on 64 bit os

Hi Friends,

Today I got a question on “can you install SQL Server 2008 32 bit on 64 bit os?”

Answer: Yes, you can !

During setup, click on the Options link and select the architecture (64 bit or 31 bit). By default on a 64 bit OS, x64 bit will be selected. You need to change it to x86.






About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: He is on Twitter:

View all posts by Amit Bansal →

4 Comments on “Install SQL Server 2008 32 bit on 64 bit os”

  1. Hi Marc & PM, sorry for the late reply. I would simply put it as – Many ISVs have product & bit specific application support in whihc case it may be required that their application be run on specific version (even build number) and specific bit (32 bit or 64 bit) of SQL Server. HTH !

  2. I have the reverse question…can you install the 64-bit-version of SQL Server 2008 on a 32 bit OS?

Leave a Reply

Your email address will not be published.