Hi,

I have to install a new server and I am a little confused about working
combinations between 30bits, x64 and IA64...

My server use intel Xeon processors with EMT64.
So I want to install Windows 2003 x64 Ent.

but which version of SQL Server can I install?
the 64bits?
32bits + SP4 (Sql2k64sp4.exe)?

Also I have to install Reporting Services, Analysis Services & Sharepoint.
Does everything works on Win x64?

I'm using SQL Server 2000 enterprise edition.

thanks for your answer.

Jerome.

You need the SQL Server 2000 (64-bit) edition.

http://www.microsoft.com/sql/64bit/default.mspx

--
--Brian
(Please reply to the newsgroups only.)


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

what you really need; you need to wait for sql 2005 and it'll be a LOT
better

unfortunatly its an hardware migration process.
we change an old server to a new one
so we can't deploy 2005.

but I have to insure that the 64bits edition (of SQL, RS, AS) works
correctly on Win 2003 x64.
if there is any issue or compatibility problem, I'll use the 32bit edition.


<dbahooker (AT) hotmail (DOT) com> wrote

Hi

No, 32 Bit plus SP4.

SQL Server 2000 64 Bit is complied for the Intel Itanium Processor and will
not run on Xeons.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Brian Lawton" <brian.k.lawton (AT) redtailcreek (DOT) com> wrote

If you are going to install the 64-bit version of the Win2K3 make sure:
1) you install SP1 of Win2K3 x64 -- and
2) you use SP4
Both are required to run AS2K on x64 hardware with a 64-bit OS.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Thankls.

I have all of this on my CD Roms...

so finally, there is no issue in mind(?)

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

I will be deploying this same setup... Windows 2003 Standard x64
Edition running SQL Server 2000 Enterprise Edition SP4. The server I'm
running on has 8GB of RAM. Does anyone know how much RAM SQL Server
will use? My understanding is that this is not an AWE situtation
because the OS can natively address all 8GB of RAM.

Any advice on maximizing this setup would be greatly appreciated.
Thanks.

----
george sarlas
gsarlas (AT) yahoo (DOT) com

You are right, SQL Server can access up to 512Gb of RAM, which is the
maximum currently supported by Win2K3 Server.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

I've deployed the 1st of my 2 new 64-bit servers. I did have to enable
AWE in SQL Server. But to support more than 4GB of RAM, I needed to
install SQL 2000 SP4 and the SP4 AWE Hotfix
(http://support.microsoft.com/default.aspx?kbid=899761).

-george