Sunday, March 25, 2012

32bit and 64bit binaries on 64bit Windows?

Does SQL Server 2000 SP4 enable the Standard Edition to run in native x64-bi
t
mode or is it just the Enterprise Edition?
We want to consolidate our three, separate 32-bit servers for SQL Server 7,
SQL Server 2000, and SQL Server 2005 (all Standard Editions) to all run on a
single, beefed up 64-bit server.
We want to be able to simultaneously run the SQL Server 7 and SQL Server
2000 Standard Editions in the WoW64 emulator and run the SQL Server 2005
Standard Edition in native x64 bit mode.
Some of the documentation I found says “SQL Server will NOT support both
32-bit SQL in WOW and native 64-bit SQL co-existing on same server. Example:
Once you install 32-bit SQL Server Engine the server Cannot run 64-bit Engin
e
on same hardware.”
I interpret that statement to apply to each individual SQL Server engine.
Am I correct in my interpretation? Can we run the SQL Server 7 and SQL
Server 2000 Standard Editions in the WoW64 emulator and run the SQL Server
2005 Standard Edition in native x64 bit mode simultaneously on the same
64-bit server?Bump.
"John Roberts" wrote:

> Does SQL Server 2000 SP4 enable the Standard Edition to run in native x64-
bit
> mode or is it just the Enterprise Edition?
> We want to consolidate our three, separate 32-bit servers for SQL Server 7
,
> SQL Server 2000, and SQL Server 2005 (all Standard Editions) to all run on
a
> single, beefed up 64-bit server.
> We want to be able to simultaneously run the SQL Server 7 and SQL Server
> 2000 Standard Editions in the WoW64 emulator and run the SQL Server 2005
> Standard Edition in native x64 bit mode.
> Some of the documentation I found says “SQL Server will NOT support both
> 32-bit SQL in WOW and native 64-bit SQL co-existing on same server. Exampl
e:
> Once you install 32-bit SQL Server Engine the server Cannot run 64-bit Eng
ine
> on same hardware.”
> I interpret that statement to apply to each individual SQL Server engine.
> Am I correct in my interpretation? Can we run the SQL Server 7 and SQL
> Server 2000 Standard Editions in the WoW64 emulator and run the SQL Server
> 2005 Standard Edition in native x64 bit mode simultaneously on the same
> 64-bit server?
>sql

No comments:

Post a Comment