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 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...
>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...
>>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
>|||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 Express
> with it.
Ahh, cool. I didn't know that. :-)
> SQL Server 2005 Express Edition with Advanced Services is a next generation 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 unnecessary 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 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...
>>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
>>
>