Installing MSDE SQL 2000 SP4

I was working on a install for MSDE SQL SERVER 2000 when I noticed that there
was a more recent version available. I have not yet installed and wanted to
kow if the Service Pack 4 for Microsoft SQL Server 2000 - Desktop Engine
(MSDE 2000) included the Microsoft SQL Server 2000 - Database Engine
Components and the Service Pack 4 for Microsoft SQL Server 2000 - Analysis
Services Components in it's install or do I have to install them after I set
up the engine for the first time. Let me re-iterate that I am not upgrading
an instance rather I am trying to install an instance with the SP4 updates,
hoping that I get all of the tools that I can in one shot.
ANDREA,
Thank you for your answer. I have another question. I am sending these
files across a network and trying to automate the installation. I know how
to automate the MSDE install after I have extracted the files from the
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE, but is there a way to use command
lines to extract silently or maybe even feed it a path to extract to? That
way I only have to worry about one file?
ANdrew
"Andrea Montanari" wrote:

> hi,
> Thunda wrote:
> you can directly go with the sp4 version... it can both install fresh sp
> level MSDE instances as long as upgrade existing pre-sp4 instances..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>

Installing Express Issue

I have just installed Sql Express

But one installed all I have available to me is

Sql Server Config Man

Sql Server Error reporting Usage

Surface area config

IDoes any one know how to get the other features like the databases and reporting installed

thanks for any help Sammy

YOu will have to install the advanced edition for that. The normal edition does not include the reporting Service nor any database administration surface like the Management Studio.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Installation merge modules

Hi All,
Does anyone know if there is an msm available for SQLXML
3.0?
Thanks,
tom
They are not available, we only ship an MSI.
Thanks,
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"tom rageley" <trageley@.hotmail.com> wrote in message
news:206901c4ac7d$74acfd00$a601280a@.phx.gbl...
> Hi All,
> Does anyone know if there is an msm available for SQLXML
> 3.0?
> Thanks,
> tom

installation issues

Hi all,
I am trying to install SQL 2005 on my new laptop (VISTA), but for some
reason reporting services is not available to install. I have IIS installed
and the services are running. Does anyone know of a reason SRS is not
available?
TIA,
JoeHello,
check this article
http://support.microsoft.com/kb/920201
"In this scenario, you receive the following warning message for the IIS
Feature Requirement item on the System Configuration Check page in the SQL
Server 2005 Setup program:
Microsoft Internet Information Services (IIS) is either not installed or is
disabled. IIS is required by some SQL Server features. Without IIS, some SQL
Server features will not be available for installation. .... "
Best regards,
Radoslaw Lebkowski
U¿ytkownik "jaylou" <jaylou@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:C53A4956-A42D-4EE7-BB34-273B0A97F09A@.microsoft.com...
> Hi all,
> I am trying to install SQL 2005 on my new laptop (VISTA), but for some
> reason reporting services is not available to install. I have IIS
> installed
> and the services are running. Does anyone know of a reason SRS is not
> available?
> TIA,
> Joe