Where is SSMS/SSMS-EE

Question

Post reply

Where is SSMS/SSMS-EE

ps.

One Orange Chip

Points: 29423
More actions
December 20, 2008 at 5:28 am

#204220

HI i downloaded express edition of 2005 and installed it on my laptop... I cant find none of the tools to use the database. All i see is the SQLServer(SQLExpress) service running.
I learnt SSMS is not included with the setup, instead SSMS-EE. But i cant find that as well, not even on net for downloads.
Any Help!!
All i want is to install the free version of 2005 and test it.. Any other versions/installation will also be helpful.
Thanks.

Pradeep Singh

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Here is the install path on my machine (Note I also have SQL 2000 installed). What you are looking for is: ssmsee.exe

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ssmsee.exe"

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

ps. One Orange Chip Points: 29423 More actions · Answer 2

i installed the 53 MB Express edition.. I dont see the VSShell folder under BINN folder.. also searched for ssmsee.exe on my hard drives... didnt find it..

I had also installed .NET 2.0 before installation.

There was just one installation file and was smooth till end without any error or warning.

I'm downloading the full evaluation version but seems it'd take another 15 hours or so on my datacard....

I want to download the complete free version... Any link to download other free version? i cant find one... tried finding ssmsee.exe on net but of no help..

Pradeep Singh

Lowell SSC Guru Points: 323546 More actions · Answer 3

you need to find the SQL Server Express 2005 with Advanced Services:

Microsoft SQL Server 2005 Express Edition with Advanced Services

that contains the Express version of SS management Studio

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ps. One Orange Chip Points: 29423 More actions · Answer 4

Thanks Lowell. I was just wondering how much they've squeezed to make an express edition in just 50 MB where as enterprise one takes more than 800 MB.

This one has a size of around 250 MB.

I'd take atleast 4 more hours... I'll let u know upon installation.

Pradeep Singh

Ron McCullough SSC Guru Points: 63877 More actions · Answer 5

PS

Another option for you is to install the Developer version of SQL 2005. The last time I looked it was available on AMAZON.COM for a price of $48.89 (U.S. dollars) or the developer edition of SQL 2008 same site same price. It comes on a CD and for just a modest additional cost you can have it delivered in 2 days. The license requires you to NOT use in a Production set up. The developer edition gives you so much more than the express I believe it to worth the $$.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Lowell SSC Guru Points: 323546 More actions · Answer 6

yeah i carry the advanced version on a flash drive now that I've downloaded it;

i had a problem with VS 2005 installing; It would only install if i explicitly skipped allowing it to install SQL Express, so then i went thru the same steps you did...installed express, found there was no interface, and had to upgrade.

At least now i know what i was missing.

As bitbucket suggested, later i ponied up a few bucks for the Developer version, so now I can play with ssis and analysis services

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ps. One Orange Chip Points: 29423 More actions · Answer 7

Thanks Lowell and bitbucket.

Finally i got it working. Everything is in place now, including sample databases 🙂

Though i have msde, standard and enterprise of 2000; and msde, enterprise of 2005 at my workplace, i wanted to have something on my machine to keep myself busy during weekends.

and that $50 or so is a good bargain as i'll have near enterprise edition version on my desktop 🙂

Pradeep Singh