Re: SQL Server Management Studio Express 2008

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Dale,

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.fye@xxxxxxxxxx> wrote in message news:erwuTGEEJHA.680@xxxxxxxxxxxxxxxxxxxxxxx
Like an idiot, I downloaded and upgraded my 2005 SQL Server Express to the 2008 version, without first checking the newsgroups to look for problems I might encounter. Well, I now have a SQL Server Express 2008 database, but no Management Studio.

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.


.

Relevant Pages

  • Re: Where is SQL Management Studio?
    ... Run setup from your sql server dvd and select database engine, ... installation features selected) and can't figure out how I am supposed to ... None of these puts up an UI that I can use to develop databases! ... Management Studio, but I don't ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Management Studio Express 2008
    ... SQL Server 2008 Express Edition with Tools and Advanced Services have SQL ... Server Management Studio Basic with them and this feature is ... However, if you did not check it during an installation, you can simply ...
    (microsoft.public.sqlserver.setup)
  • Re: Connextion Error After Installing SQL Server 2005 on Vista
    ... Bob-PC\SQLServer2005MSSQLUser$BOB-PC$MSSQLSERVER is used by the SQL Server Database Engine Service. ... What you want is an individual login. ... Then you will be able to connect with Management Studio without using your Administrators credentials. ... During the installation, I was prompted a couple of times to install a service pack for Visual Studio 2005, which is not currently installed. ...
    (microsoft.public.sqlserver.connect)
  • Re: Installing SQL on Server and Client PCs
    ... When you place the start the installation CD you can choose justo to install ... Management Studio and connect to the Server. ... I have SBS 2003 R2 with SQL Server 2005 Workgroup edition installed. ...
    (microsoft.public.sqlserver.setup)
  • [NT] SQL Server Installation Process May Leave Passwords on System
    ... service pack for SQL Server 7.0 or SQL Server 2000, ... without having to actually perform an installation. ... to SQL Server 7.0 Service Pack 4, the passwords were stored in clear text. ... information in the setup.iss and log files would not allow any access. ...
    (Securiteam)