can't find SQL Server Management Studio

[stevenriz]

Hi, we have installed the SQL Server 2005 Trial twice now and still cannot find the SQL Server Management Studio or EM. The menu for SQL Server only has these things in it
Configuration Tools
- SQL Server COnfiguration Manager
- SQL Server Error and Usage Reporting
- SQL Server Surface Area Configuration
- Notification Services Command Prompt
- Reporting Services Configuration

Should we see more menu items? I did do the the complete install.
Thoughts?

 

[yetanotherjo]

Unless you download and install Express advanced, I think you download and install it seperately with the freebie versions. There's a link here:

http://msdn.microsoft.com/vstudio/express/sql/default.aspx

 

[stevenriz]

We had express on there but my boss asked to have the full 2005 installed instead. I downloaded this one.

http://www.microsoft.com/sql/downloads/trial-software.mspx#EJB

I would have thought this version has everything express has plus more. Am I wrong to assume that?

 

[yetanotherjo]

Seems a fair assumption to expect it to be there:

SQL Server 2005 Developer Edition and Evaluation Edition are not listed in the tables. These editions have the same feature set as the Enterprise Edition; the only difference between these editions is the licensing policies.

Sorry, but in that case, I have no idea...using Express here...were you given an option of what was installed? Was there a "hide advanced options" or some-such check box during your install and did you uncheck it?

 

[stevenriz]

No not that I know of. I selected to install entire feature on the local hard drive. PArt of that feature is the management studio. When I try to reinstall it, it tells me it is already installed. Do you know what exe file is run to start that program? Maybe I Can find it on the hard drive and create a link for it separately. Otherwise I need to remove it and try it all over again from scratch.

 

[yetanotherjo]

Mine ended up here by default: "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ssmsee.exe"...Can you see it in Add & Remove Programmes in the Control Panel? Mine shows up seperately (but I'm not sure if this is an Express thing).