Installed Sql server 2008, but management studio missing.

I have installed sql server 2008 express edition from the following location :
http://www.microsoft.com/downloads/details.aspx?FamilyID=58ce885d-508b-45c8-9fd3-118edd8e6fff&displaylang=en

File :: SQLEXPR_x86_ENU.exe

But I get only "Configuration Tools" and "Import and Export Data" items under the Start Menu.

Do I need to install management studio separately ?
LVL 2
puneetdudejaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
Yes. Management Studio isn't part of the Express install, but it can be downloaded as a seperate package here: http://www.microsoft.com/downloads/details.aspx?FamilyID=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en
0
 
slam69Connect With a Mentor Commented:
Hi, whilst your at the basic install stage, consider installing 2008 express with advanced tools. if you want to do any reporting using ssrs you would need this one, has a few extra bits as well which are described on the page
e
http://www.microsoft.com/downloads/details.aspx?FamilyID=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en
0
 
Jagdish DevakuConnect With a Mentor Sr DB ArchitectCommented:
Hi,
Please check the link to download and install management studio.
http://www.microsoft.com/downloads/details.aspx?FamilyID=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en
MSXML 6.0 Parser, .Net Framework 2.0, Windows Installer 4.5 or above and PowerShell are pre requisties.
MSXML: http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
.Net FW: http://www.microsoft.com/downloads/details.aspx?familyid=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en
Windows Installer: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=5a58b56f-60b6-4412-95b9-54d056d6f9f4
PowerShell: http://support.microsoft.com/kb/968929  (Will be installed SQL Server 2008 Express)
Let me know if you have any questions...
Bye.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
puneetdudejaAuthor Commented:
I have downloaded 32 bit version of Management Studio from microsoft site ::
SQLManagementStudio_x86_ENU.exe

Getting the error :: This is not a valid win32 application.
0
 
Jagdish DevakuConnect With a Mentor Sr DB ArchitectCommented:
hi,
You will be getting this error for the following reasoning.
File is corrupt, bad, or missing.
File is not designed for your version of Windows.
File is a virus, worm, or other malware file.
Hardware incompatibility.
Please let us know the the version of your OS.
Please check the requirements from the below link...
http://www.microsoft.com/downloads/details.aspx?FamilyID=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en#Requirements
Bye.
 
0
 
marirajuConnect With a Mentor Commented:
Hi there,

Although you might have got some of the answers I would like to mention some of the things.
First of all, Yes, you have to install SSMS seperately available at the following link

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

While installing SQL Server express you might come across many problems, such as MSXML6.0 error, which was installed as a part of the update to the system. If you get this error please uninstall MSSML6.0 and then try to install again.

So, as you know, you can install SQL server by using command line options for various needs, which can include network options, SQL Browser, type of installation etc.. If you need more info on this please do let me know.
To run the SQL installation with Basic screens, try using SQLEXP32**.EXE /qb
To run the SQL installation with no screen, which is quiet mode, try using SQLEXP32**.EXE /qn
With the basic at least you come to know the errors visually.

One more thing to remember,
Once you install SQL express, and SSMS, you will have the SQLCMD utility(where you can run all the commands, which also provides DAC-Dedicated Administration Connection) that comes with that. If you miss that you can download that from the following location.
http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

If you are planning to use FULL TEXT SEARCH, you don't get that option . So please if you need that feature, please download the advanced SQL express installation file from the following link.

Microsoft® SQL Server® 2008 Express with Advanced Services
http://www.microsoft.com/downloads/details.aspx?FamilyID=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en


Other System Requirements

•Microsoft .Net Framework 3.5 SP1.
•Windows Installer 4.5.

Please do contact me for further help.

Bye for now

Cheers
0
All Courses

From novice to tech pro — start learning today.