installing sql server 2005 express with advanced services sp2

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?
DanielAFAIK, the tools is a separate download (SQL Server Management Studio Expres
s).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>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 installe
d to help me view and
>manage the database files. Could I just rerun the installation and add tho
se in? Which options do
>I need to choose to install those needed tools?
> Daniel
>|||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 nsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
> AFAIK, the tools is a separate download (SQL Server Management Studio
> Express).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Brower" <newstbs@.cableone.net> wrote in message
> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>|||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 nsoy
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>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
>|||> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Ex
press
> with it.
Ahh, cool. I didn't know that. :-)

> SQL Server 2005 Express Edition with Advanced Services is a next generatio
n of SQL Server 2005
> Express Edition. They all are for free.
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 un
necessary stuff.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:238E4914-3A21-468D-BC2B-6EDE2D7B411E@.microsoft.com...
> SQL Server 2005 Express Edition with Advanced Services has SQL Server Mana
gement Studio Express
> with it.
> This is one of the additional feature of this edition of SQL Server 2005 E
xpress.
> 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) h
owever 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 b
e 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 t
his:
> SQL Server 2005 Express Edition with Advanced Services is a next generatio
n of SQL Server 2005
> Express Edition. They all are for free.
> --
> Ekrem nsoy
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
>sql