installing sql server 2005 express with advanced services sp2

installing sql server 2005 express with advanced services sp2

Post by Daniel Bro » Sat, 17 Nov 2007 15:09:50


I just installed SQL Server 2005 Express Edition with Advanced Services SP2
with the default installations options. I found afterwards that there are
no tools installed to help me view and manage the database files. Could I
just rerun the installation and add those in? Which options do I need to
choose to install those needed tools?

Daniel
 
 
 

installing sql server 2005 express with advanced services sp2

Post by Tibor Kara » Sat, 17 Nov 2007 16:44:25

AFAIK, the tools is a separate download (SQL Server Management Studio Express).

--
Tibor Karaszi, SQL Server MVP
http://www.yqcomputer.com/
http://www.yqcomputer.com/

 
 
 

installing sql server 2005 express with advanced services sp2

Post by Ekrem so » Sat, 17 Nov 2007 17:59:08

SQL Server 2005 Express Edition with Advanced Services has SQL Server
Management Studio Express with it.

This is one of the additional feature of this edition of SQL Server 2005
Express.

However, there is no SSMSE with SQL Server 2005 Express Edition

I have not setup this edition of SQL Server yet (I'm downloading it now)
however in the other editions of SQL Server there is a setting in Components
to Install window in SQL Server setup. You should check Client
Tools\Management Tools option in SQL Server Setup to be able to install this
GUI to manage your SQL Server Instances.

I'll let you know how to install management tools after testing it.

P.S.
Daniel, I just do not want to cause any confusion so I wanted to clarify
this:

SQL Server 2005 Express Edition with Advanced Services is a next generation
of SQL Server 2005 Express Edition. They all are for free.

--
Ekrem soy



"Tibor Karaszi" < XXXX@XXXXX.COM > wrote in
 
 
 

installing sql server 2005 express with advanced services sp2

Post by Ekrem so » Sat, 17 Nov 2007 19:14:02

Hello Daniel,

I performed the test.

To install only SQL Server Management Studio Express for SQL Server 2005
Express Edition with Advanced Services follow this path:

- Extract your setup files to a folder using this command "sqlexpr_adv.exe
/x". Setup will ask you for a folder for extraction.
- Go to that extracted setup files folder and open Setup folder and find
"sqlserver2005_ssmsee" file and run it.

This will install SQL Server Management Studio Express

P.S.
Run "sqlserver2005_ssmsee_x64" if your system is x64.

--
Ekrem soy
 
 
 

installing sql server 2005 express with advanced services sp2

Post by Tibor Kara » Sat, 17 Nov 2007 19:28:43

> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Express

Ahh, cool. I didn't know that. :-)



To the best of my knowledge, the two are both equally "current generation". The regular express is
kept with minimal features so it is quick to download and (can) only install core services. This can
be important both for download speed and to not "litter" the machine with unnecessary stuff.

--
Tibor Karaszi, SQL Server MVP
http://www.yqcomputer.com/
http://www.yqcomputer.com/