Microsoft SQL Server/System Requirements

From Wikibooks, open books for an open world
< Microsoft SQL Server
Jump to: navigation, search

The 32bit editions are different to the 64 bit editions

32 Bit[edit]

Minimum processor: PIII 600 (1 GHZ or faster recommended) Minimum OS:

Enterprise[edit]

Windows Server 2003 (Standard, Enterprise or Datacenter) with SP1 or later Windows Small Business Server 2003 (Standard or Premium) with SP1 io later Windows 2000 (Server, Advanced Server, Datacenter Server) with SP4 or later

In Short: All OS except WinXP

Standard[edit]

All of Enterprise, but also non server windows os.

Windows Professional with SP4 and Windows XP with SP2 or later

Workgroups[edit]

All of standard and Windowns XP Media and Tabled Edition

Express[edit]

All of the above + Windows Home Edition with SP2 or later and Windows Server 2004 Web Edition with SP1 or later

Developer[edit]

1+2+3 + 4.5 Windows Home Edition with SP2

Memory Requirements[edit]

Enterprise, Development Standard and Workgroup: 512 min, 1 GB more recommended Express: 192 min, 512 or more recommended

Harddisk requirement[edit]

350 MB full and 390 for sample

Internet[edit]

  • Explorer SP1 required for all installations (Required for Microsoft Management Console (MMC) and HTML Help.
  • IIS Required for XML applications and for Reporting Services
  • TCP/IP must be enabled


64-Bit Editions of SQL Server 2005[edit]

Processor[edit]

IA64 Minimum: 1 GHZ or faster Itanium X64 minimuM. 1 Ghz or faster AMD Opteron, AMD Athlon 64, Intel Xenon with Intel EM64T support or PIV with EM64T support