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.
Best Answer
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.