I'vr run the SQL Server Installation Center, and have been through about
every option combination I can think of, but cannot find an option to
install the SSMS. I've checked the news groups, but even the couple of
posts that I've seen have not provided specific instructions.
Would really appreciate some help here, as I was hoping to work on my
database this weekend.
Thanks.
Express with Advanced Services:
http://www.microsoft.com/downloads/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-
B0D0-1311D670E336
Express with Tools:
http://www.microsoft.com/downloads/details.aspx?FamilyId=7522A683-4CB2-454E-
B908-E805E9BD4E28
On 9/6/08 12:52 PM, in article erwuTGE...@TK2MSFTNGP03.phx.gbl, "Dale
Express with Advanced Services is the one I used. I'm sure that somewhere
in the Installation Center, there is a way to activate/install the SSMS, but
I cannot find it.
I cannot afford to uninstall SQL Server 2008, since I did the upgraded from
2005, and my 2005 database is no longer available.
"Aaron Bertrand [SQL Server MVP]" <ten...@dnartreb.noraa> wrote in message
news:C4E83662.11B70%ten...@dnartreb.noraa...
it is possible, via SQLExpressWT or SQLExpressWAS, to install just the
SSMSBasic tool..
If you installed the basic package of SQLExpress 2008 (but you did not, as
you used SQLExpressWAS), you have to upgrade the installed instance (basic)
to the one With Advanced Service before trying to install the SSMSBasic
tool... but, using the reported packages, you can install, if you like, just
the tool on a clean machine not hosting SQLExpress as well.. you are just
required to install Windows Installer 4.5 upgrade, Net FWK 3.5sp1 and
PowerShell thought...
please have a look at my own "experiences" installing SQLExpress 2008 at
http://www.asql.biz/Articoli/SQLX08/Art1_1.aspx
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply
SQL Server 2008 Express Edition with Tools and Advanced Services have SQL
Server Management Studio Basic (SSMSB) with them and this feature is called
"Management Tools - Basic" and you can check this feature to be installed
during SQL Server 2008 Express Edition installation. It's in the Feature
Selection window as the other features.
However, if you did not check it during an installation, you can simply
install it by running the SQL Server 2008 Express Edition (x) Setup. So this
means that you don't have to install another instance of SQL Server 2008
Express Edition to install SSMSB.
During this installation process, in the Installation Type window you should
simply select "Add features to an existing instance of SQL Server 2008" and
then select the existing SQL Server 2008 instance name -which you have
already installed- in the dropdown box. Then keep going. You'll come to the
Feature Selection window. Here, if SSMSB is not installed then you'll see
that the checkbox (Management Tools - Basic) with it is enabled and
unchecked. Then check this feature and keep installing.
P.S.
I've tested it for you, it simply works.
--
Ekrem Önsoy
"Dale Fye" <dale...@nospam.com> wrote in message
news:erwuTGE...@TK2MSFTNGP03.phx.gbl...
I found it late yesterday evening. I was bypassing it because I was
choosing one of the wrong options earlier in the process.
Thanks to everyone for the assistance.
Dale
"Ekrem Önsoy" <ek...@compecta.com> wrote in message
news:A166CCD8-69CE-432F...@microsoft.com...
If so, ensure that the SSMSE Setup was downloaded correctly. It may be
corrupted or timed out while being downloaded. Its file size must be 38.4MB.
--
Ekrem Önsoy
"Marc" <Ma...@discussions.microsoft.com> wrote in message
news:42614E77-A24B-4268...@microsoft.com...
http://www.asql.biz/Articoli/SQLX08/Art1_2.aspx
Follow these procedures and SSMSE will be up and running. Best of luck to all!
--
Ekrem Önsoy
"Marc" <Ma...@discussions.microsoft.com> wrote in message
news:FEC5F1D0-071A-4924...@microsoft.com...
On 10/9/08 4:34 AM, in article
5C12152A-0992-4D57...@microsoft.com, "Ekrem Önsoy"
--
Ekrem Önsoy
"Aaron Bertrand [SQL Server MVP]" <ten...@dnartreb.noraa> wrote in message
news:C5139F1F.14285%ten...@dnartreb.noraa...
On 10/10/08 4:03 AM, in article
0BB50CDD-A813-41AB...@microsoft.com, "Ekrem Önsoy"
--
Ekrem Önsoy
"Aaron Bertrand [SQL Server MVP]" <ten...@dnartreb.noraa> wrote in message
news:C514DD77.14413%ten...@dnartreb.noraa...