SQL Server - Sql Server 2005 Express Edition - Asked By Meyyappan Palaniappan on 11-Oct-06 03:30 AM

Hi All,

We developed a windows based application in visual studio 2005 having SQL Server 2005 express edition as backend.

We developed a setup and deploymemt kit for this and want to install this kit in windows 2000 profesional and windows 2000 server OS.

When i am installing SQL server 2005 express edition in windows 2000 OS to run my simple windows application, Is IIS required or not?

Regards

P.L.Meyyappan

Hardware and Software Requirements (SQL Server Express) - K Pravin Kumar Reddy replied to Meyyappan Palaniappan on 11-Oct-06 03:33 AM

hello

Updated: 17 July 2006

The following tables list the prerequisite software and minimum hardware and software requirements for running Microsoft SQL Server 2005 Express Edition (SQL Server Express), Microsoft SQL Server 2005 Express Edition with Advanced Services (SQL Server Express), and Microsoft SQL Server 2005 Express Edition Toolkit (SQL Server Express Toolkit).

Note:
To determine if the computer meets the system requirements, from the Start menu, right-click My Computer, and then click Properties. The General tab displays the CPU type and speed, and the amount of installed memory (RAM).

var ExpCollDivStr = ExpCollDivStr; ExpCollDivStr = ExpCollDivStr + "ctl00_LibFrame_ctl0617a316e,"; var ExpCollImgStr = ExpCollImgStr; ExpCollImgStr = ExpCollImgStr + "ctl00_LibFrame_ctl06img,"; http://msdn2.microsoft.com/en-us/library/ms143680.aspx#
http://go.microsoft.com/fwlink/?linkid=45988
  • SQL Server Setup requires Microsoft Data Access Components (MDAC) 2.8 SP1 or later. You can download MDAC 2.8 SP1 from this http://go.microsoft.com/fwlink/?linkid=50233.
  • Internet Requirements

    Microsoft Internet Explorer 6.0 SP1 or later (prerequisite for .NET Framework)

    RAM

    Minimum: 192 MB

    Recommended: 512 MB or higher

    Hard Disk space

    600 MB free space

    Processor

    Pentium III Compatible or higher

    Minimum: 500 MHz

    Recommended: 1 GHz or higher

    Operating System

    Windows Server 2003 SP1

    Windows Server 2003 Enterprise Edition SP1

    Windows Server 2003 Datacenter Edition SP1

    Windows Small Business Server 2003 Standard Edition SP1

    Windows Small Business Server 2003 Premium Edition SP1

    Windows XP Professional SP2

    Windows XP Home Edition SP2

    Windows XP Tablet Edition SP2

    Windows XP Media Edition SP2

    Windows 2000 Professional Edition SP4

    Windows 2000 Server Edition SP4

    Windows 2000 Advanced Edition SP4

    Windows 2000 Datacenter Server Edition SP4

    Virtual PC

    Virtual Server

    Note   There is no support in this release for Windows XP Embedded Edition.

    var ExpCollDivStr = ExpCollDivStr; ExpCollDivStr = ExpCollDivStr + "ctl00_LibFrame_ctl093a45dd0,"; var ExpCollImgStr = ExpCollImgStr; ExpCollImgStr = ExpCollImgStr + "ctl00_LibFrame_ctl09img,"; http://msdn2.microsoft.com/en-us/library/ms143680.aspx#
    http://go.microsoft.com/fwlink/?linkid=45988
  • SQL Server Setup requires Microsoft Data Access Components (MDAC) 2.8 SP1 or later. You can download MDAC 2.8 SP1 from this http://go.microsoft.com/fwlink/?linkid=50233.
  • Internet Requirements

    • Microsoft Internet Explorer 6.0 SP1 or later (prerequisite for .NET Framework)
    • Internet Information Services (IIS) 5.0 or later is required for Microsoft SQL Server 2005 Reporting Services (SSRS) installations.
      For more information on how to install IIS, see http://msdn2.microsoft.com/en-us/library/ms143748.aspx in SQL Server 2005 Books Online.

    RAM

    Minimum: 512 MB

    Recommended: 1GB or higher

    Hard Disk space

    600 MB free space

    Processor

    Pentium III Compatible or higher

    Minimum: 600 MHz

    Recommended: 1 GHz or higher

    Operating System

    Windows Server 2003 SP1

    Windows Server 2003 Enterprise Edition SP1

    Windows Server 2003 Datacenter Edition SP1

    Windows Server 2003 Web Edition SP1

    Windows Small Business Server 2003 Standard Edition SP1

    Windows Small Business Server 2003 Premium Edition SP1

    Windows XP Professional SP2

    Windows XP Tablet Edition SP2

    Windows XP Home Edition SP2¹

    Windows XP Media Edition SP2¹

    Windows 2000 Professional Edition SP4

    Windows 2000 Server Edition SP4

    Windows 2000 Advanced Edition SP4

    Windows 2000 Datacenter Server Edition SP4

    Virtual PC

    Virtual Server

    Note:
    There is no support in this release for Windows XP Embedded Edition

    ¹Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS).

    var ExpCollDivStr = ExpCollDivStr; ExpCollDivStr = ExpCollDivStr + "ctl00_LibFrame_ctl1392774da,"; var ExpCollImgStr = ExpCollImgStr; ExpCollImgStr = ExpCollImgStr + "ctl00_LibFrame_ctl13img,"; http://msdn2.microsoft.com/en-us/library/ms143680.aspx#
    http://go.microsoft.com/fwlink/?linkid=45988
  • SQL Server Setup requires Microsoft Data Access Components (MDAC) 2.6 or later. You can download MDAC 2.8 SP1 from this http://go.microsoft.com/fwlink/?linkid=50233.
  • Internet Requirements

    • Microsoft Internet Explorer 6.0 SP1 or later (prerequisite for .NET Framework)
    • Internet Information Services (IIS) 5.0 or later is required for Microsoft SQL Server 2005 Reporting Services (SSRS) installations.
      For more information on how to install IIS, see http://msdn2.microsoft.com/en-us/library/ms143748.aspx in SQL Server 2005 Books Online.

    RAM

    Minimum: 512 MB

    Recommended: 1GB or higher

    Hard Disk space

    600 MB free space

    Processor

    Pentium III Compatible or higher

    Minimum: 600 MHz

    Recommended: 1 GHz or higher

    Operating System

    Windows Server 2003 SP1

    Windows Server 2003 Enterprise Edition SP1

    Windows Server 2003 Datacenter Edition SP1

    Windows Server 2003 Web Edition SP1

    Windows Small Business Server 2003 Standard Edition SP1

    Windows Small Business Server 2003 Premium Edition SP1

    Windows XP Professional SP2

    Windows XP Tablet Edition SP2

    Windows XP Home Edition SP2

    Windows XP Media Edition SP2

    Windows 2000 Professional Edition SP4

    Windows 2000 Server Edition SP4

    Windows 2000 Advanced Edition SP4

    Windows 2000 Datacenter Server Edition SP4

    Virtual PC

    Virtual Server

    Note:
    There is no support in this release for Windows XP Embedded Edition

    ¹Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS).

    reference

    http://msdn2.microsoft.com/en-us/library/ms143680.aspx

    Sql Server 2005 Express Edition & IIS - mv ark replied to Meyyappan Palaniappan on 11-Oct-06 04:07 AM

    IIS is required if you are going to use SQL Server 2005 Reporting Services (SSRS)