Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Computers » Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Fri, 26 Oct 2007 18:55:30 GMT

PingBack from http://www.soundpages.net/computers/?p=5179

Computers » Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Fri, 26 Oct 2007 18:56:43 GMT

PingBack from http://www.soundpages.net/computers/?p=5179

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Dan — Fri, 26 Oct 2007 20:41:20 GMT

Damn, I did this yesterday... I ran the sql 2005 installer at least 15 times, what a nightmare.

Anyway I'm a Metallica fan :)

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Tom Garth — Mon, 29 Oct 2007 16:53:37 GMT

Alas. It would have helped me a couple of months ago. It wasn't the express edition, but the full Management Studio that I needed to uninstall on a Virtual PC that had been running SQL 2000, but had 2005 Management Studio installed for other reasons. The real problem is that SP2 had already been applied, so it was not compatible with the reinstall.

MS has a little work to do there if you ask me. I lost about 2 hours that day.

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

DM — Tue, 30 Oct 2007 00:38:44 GMT

Here is the link to Microsoft SQL Server Management Studio Express. Just download it and install. Take a few minuts. Worked for me just fine.

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

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Steve — Sun, 04 Nov 2007 13:46:27 GMT

Thank you for making me feel better!

I too, attempted to Install SSMS over SSE about 6 months ago. I gave up after almost a full day and just resolved to continue with SSE. A feew weeks ago, I again made the attempt to install SSMS. I can't recall exactly how I finally got it to run, it only took another day....

I wanted to let others know what I did to get it to install but though:

1) It is just my NEWB status that caused so much effort to be required and...

2) After running around the same tree all day, I had (and still have) no idea what I actually did to get it installed.

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

JRBII — Wed, 07 Nov 2007 00:59:41 GMT

worked for me! Now I can install SQL Refactor... I copied this info and put it in my blog with a reference to yours.

thanx alot!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Clive Chinery — Thu, 08 Nov 2007 13:54:14 GMT

I only had a default SQL Express but had exactly the same problem. Your fix worked! - Thank you!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Greg Dyck — Wed, 12 Dec 2007 22:23:52 GMT

Simple and neat. Worked for me too.

Thanks for posting your solution for all to see.

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Paul Hauer — Fri, 08 Feb 2008 17:35:05 GMT

Thank you, was already at the despair. I have also worked out :)

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

George — Tue, 12 Feb 2008 04:30:05 GMT

I found that if you find the SQL Server Express installed the installer provides a warning message about edition changes. Click the warning message and you find that you need to run the install from the command line with an upgrade parameter.

To do this - Suppose your CD is in D:

D:setup.exe SKUUPGRADE=1

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Paulo — Tue, 26 Feb 2008 16:26:26 GMT

Thanks a lot... I did head bang for a while before finding this, but it's ok, I like Metallica. ^^

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Jason — Fri, 11 Apr 2008 20:35:39 GMT

Thanks. Saved me a lot of trouble at a client site :)

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Luke — Mon, 28 Apr 2008 21:18:56 GMT

Thanks, your instructions helped save me a bunch of time.

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Darryl — Wed, 28 May 2008 05:36:56 GMT

Thanks! This saved me as well. I was just trying to install the BDIS component and got the above error. I ended up removing SSMSE to try and solve it but if I'd found this post first I probably wouldn't have needed to!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Dave Stuart — Thu, 29 May 2008 00:55:25 GMT

Thanks for this. It didn't save me a wasted day or a massive headache but at least I can go home at the end of this day knowing that I might actually get some work done in the morning. I ran around that tree all day long. Thanks again for taking the time to provide this answer for everyone.

Dave

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Minal — Mon, 02 Jun 2008 04:21:47 GMT

Thanks a million.

I had hit a hard wall, trying to install the developer edition if SSMS.

You tips above worked superb.

Thanks.

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

robin — Tue, 03 Jun 2008 01:52:03 GMT

Thanks mate! it worked, appreciate!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Vivek M. Chawla — Tue, 10 Jun 2008 23:58:06 GMT

Thank you very much for providing this information. I followed your instructions and it worked like a charm.

Windows Vista has been nothing but trouble, but you've saved me a few hours of further frustration today. You're a hero today, friend!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Andy C — Fri, 13 Jun 2008 16:46:08 GMT

Thanks for that - although had quite a relaxing day watching little progress bars ambling across the screen and repeatedly rebooting my increasingly warm laptop. Glad to finally get it resolved.

....a little something from Master of Puppets for me please.

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Ori — Wed, 18 Jun 2008 19:17:57 GMT

sharing is caring! :)

thanx alot!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Dirk — Fri, 27 Jun 2008 10:48:21 GMT

Thanks a ton! You definitely saved me a lot of time.

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Me — Tue, 12 Aug 2008 10:25:05 GMT

Thanks a ton! This is exactly what I needed! Cheers!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Mon — Wed, 13 Aug 2008 18:55:20 GMT

The running "setup.exe SKUUPGRADE=1" without the quotes worked for me. Thanks!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Mon — Wed, 13 Aug 2008 18:56:27 GMT

Running "setup.exe SKUUPGRADE=1" without the quotes in the command prompt worked for me. Thanks!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Jen — Fri, 29 Aug 2008 03:28:07 GMT

Thank you so much for this! We tried everything to install Management Studio Dev over Express. Nice job.

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

HCF — Thu, 11 Sep 2008 20:40:14 GMT

Bless you for this info! I've been trying to find a way to do this, on and off, for months!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

chris fontan — Tue, 07 Oct 2008 23:54:58 GMT

great..

Tags:

order of installation for sql server 2005 and visual studio 2008

Install sql server first.. Then VS 2008

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Vin — Wed, 26 Nov 2008 04:15:42 GMT

http://cogniscribe.blogspot.com/2008/11/installing-sql-server-management-studio.html

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Dan — Thu, 12 Mar 2009 14:44:52 GMT

Thanks... saved me a lot of time.

Dan

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

AL — Fri, 31 Jul 2009 14:11:16 GMT

Top class, thanks for sharing!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Jerome Paradis — Sun, 30 Aug 2009 05:13:13 GMT

Thanks! You just saved me quite a few headaches. Lost 30 minutes struggling on the SQL tools setup before finding your article.

Cheers!

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Harrison — Wed, 18 Nov 2009 09:31:35 GMT

Well done! This save my life...and my job...

re: Installing SQL Server Management Studio when you already have Management Studio Express installed!!!

Derek — Fri, 20 Nov 2009 22:32:44 GMT

Thank you very much, much frustration until I found this post!