After installing a 32 bit version of SQL 2000 on a 64 bit Windows 2003
Server, we realize that it gets installed within C:\Program Files (x86). Can
it be installed within the 64 bit directory C:\Program Files? Would this
work, or would there be issues?

The reason we want it installed in this direct is; the Replication Software
(Double Take) we are using to Replicate our database recommands that the
installation of our Target Server be the same as the Source. Meaning the
installation paths have to be the same.

Thanks in advance,
Shannon

Shannon,

It is installed in C:\Program Files (x86) because that is where the 32-bit
code, including other system DLLs are stored. I do not believe that the
installer will let you install in the 64-bit directory and, if you somehow
forced it to do so, the code would be coexisting with the wrong DLLs.

In general, you cannot call DLLs built for a different bit code, no 32 to 64
and definitely no 64 to 32.

RLF

"SEgerton" <SEgerton (AT) discussions (DOT) microsoft.com> wrote

Shannon,

Russell is right. If you are using double take software then you need to
concentrate only on replicating user databases and you will be placing the
physical files of these data files to some other path.