Can you run 64-bit and 32-bit SQL server on same 64-bit Server?

Can you run 64-bit and 32-bit SQL server on same 64-bit Server?

Post by Q2F0cmluY » Sat, 31 Jan 2009 23:47:01


I'm new to SQL Server, so please forgive my ignorance. One project I'm being
tasked with is a SQL Server consolidation and reorganization. In terms of
hardware, if we have a 64bit server, could it run 2 instances of SQL Server
(one for 32 bit apps and another for 64 bits apps) or do we need 2 different
servers?
 
 
 

Can you run 64-bit and 32-bit SQL server on same 64-bit Server?

Post by Tom Morea » Sat, 31 Jan 2009 23:54:02

Yes, you can run both 32-bit and 64-bit SQL Server on the same machine.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau




I'm new to SQL Server, so please forgive my ignorance. One project I'm
being
tasked with is a SQL Server consolidation and reorganization. In terms of
hardware, if we have a 64bit server, could it run 2 instances of SQL Server
(one for 32 bit apps and another for 64 bits apps) or do we need 2 different
servers?

 
 
 

Can you run 64-bit and 32-bit SQL server on same 64-bit Server?

Post by Jeffrey Wi » Tue, 03 Feb 2009 04:28:14

But, I would have to ask why?

There is no reason that I am aware of where an application that connects to
SQL Server requires SQL Server to be 32bit. The application shouldn't care
whether the database engine is 64bit or 32bit at all.

Jeff
 
 
 

Can you run 64-bit and 32-bit SQL server on same 64-bit Server?

Post by Tom Morea » Tue, 03 Feb 2009 22:30:52

Re-reading the OP, I see what you mean. She really only needs one instance
then. I thought the OP was just asking about the coexistence of 32 bit and
64 bit on the same box.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau




But, I would have to ask why?

There is no reason that I am aware of where an application that connects to
SQL Server requires SQL Server to be 32bit. The application shouldn't care
whether the database engine is 64bit or 32bit at all.

Jeff
 
 
 

Can you run 64-bit and 32-bit SQL server on same 64-bit Server?

Post by Jeffrey Wi » Fri, 06 Feb 2009 02:52:49

I get this all the time - in fact, I have some vendors who insist that their
application will not work if connecting to an x64 version of the database.
Of course, after talking to them a bit about it - we find out that the
reason they came to that conclusion is because their web based application
is also running on the same server as the database and they have never
tested the system any other way.
 
 
 

Can you run 64-bit and 32-bit SQL server on same 64-bit Server?

Post by Tom Morea » Fri, 06 Feb 2009 08:25:01

I hope you charge them big bucks. They deserve it!

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau




I get this all the time - in fact, I have some vendors who insist that their
application will not work if connecting to an x64 version of the database.
Of course, after talking to them a bit about it - we find out that the
reason they came to that conclusion is because their web based application
is also running on the same server as the database and they have never
tested the system any other way.