0

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.

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

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.

0

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

4
  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy