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?
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
>