Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to create a 32-bit instance of SQL Server on SQL Server 2008 x64 without installing SQL Server 2008 x32? And if I have to install SQL 2008 x32; is there a problem installing both 32 and 64 on the same server?

I have some FoxPro datasources that I am needing to access via linked server. There are no 64-bit foxpro drivers that I know of.

share|improve this question

migrated from Aug 12 '10 at 21:05

This question came from our site for professional and enthusiast programmers.

Why would you want to do that? – Russ Aug 12 '10 at 14:43

yes, you can install 32 bit sql on a 64 bit machine without issue. We've done it many times. You can also have a 32 bit install sitting side by side with a 64 bit install; again no problems and yes we've done it.

You can even set up linked servers between the two if necessary.

The only way to create a 32 bit instance is to run the 32 bit installer.

share|improve this answer

The 32 bit installer will fail if you run it on a 64 bit machine. What are you trying to achieve?

share|improve this answer
No it won't - it may not run optimally but it will still run. I inherited a setup exactly like this (and quickly upgraded to 64bit Sql Server) – Macros Aug 12 '10 at 14:47
I disagree with these downvotes. I have the 32 bit installer right here failing on a 64 bit machine (sql server 2008 R2). – DanDan Aug 12 '10 at 14:49
That doesnt mean that it won't work, just that you are having a configuration problem that is preventing it from working for you. – Tommy Aug 12 '10 at 14:58
Well it fails out of the box and on a fresh machine. I won't be encouraging people to hack a 32 bit install onto a 64 bit machine; it must be discouraged and not a default setting for good reason. – DanDan Aug 12 '10 at 21:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.