How to find which types [32bit or 64bit] and versions of SQL Server can be installed?

Published 20 December 07 07:09 AM | SQL Master 

As there are more tools defaulted to 32 bit it is bit confusing for the software applications that will support X64 based installations. IN the same manner it is a common question out in the newsgroups referring to which types and versions of SQL Server can be installed. Say for instance on X86 based system SQL Server 2000 or 2005 can be installed which is by default a 32-bit application. So for x64/EMT64, and IA64 servers it is bit confusing and also with evolution of SQL Server 2005 that has different types of installations than SQL Server 2000, it is more complex for beginners in SQL world!

You may be aware the binary type of installation within SQL Server 2000 is 32-bit and 64-bit, keeping apart the edition you need to deploy. By default this version of SQL Server can be installed on x86 and even on on x64/EMT64 with an exception fo running as a 32-bit application. Ony the possibility of X64 SQL Server 2000 installation is possible on IA64 based platform.

Coming to the latest version SQL Server 2005, keeps out 3 types of installations. You can install it on x86 or x64/EMT64 as a 32-bit application, on x64/EMT64 as a 64-bit application if you’re running an x64/EMT64 Windows operating system, and on IA64 as a 64-bit application.

 

Comments

# Other SQL Server Blogs around the Web said on December 20, 2007 7:26 AM:

As there are more tools defaulted to 32 bit it is bit confusing for the software applications that will

# SSQA.net - SqlServer-QA.net said on December 20, 2007 9:20 AM:

As there are more tools defaulted to 32 bit it is bit confusing for the software applications that will

Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.