I've recently upgraded my OS to Windows 7, but this new OS wouldn't let me install SQL Server Management Studio. Is there a way to get around it?
I'm running Windows 7 with SQL Server 2005. You have to install a couple of the SQL Server SP's. You can find some good trouble shooting tips here http://support.microsoft.com/kb/955725/EN-US.
Just to make sure, verify that this is what you are trying to install:
I am running Windows 7 Ultimate on a virtual machine on my MacBook and have SQL EXPRESS 2008 installed along with SQL Management Studio without any problems. I downloaded SQL Management Studio from the link above.
Note: I also had to install SQL Express 2008 SP1 before installing SQL Management Studio from here:
Hope this helps!
SQL Server 2008 RTM will not install on to Windows 7.
But SQL Server 2008 RTM with slipstreamed SP1 will. So you need to create a slipstreamed install, this is not hard (with a little care and attention). See here, here and here for details (the first is to the official instructions, but I found the latter two links helpful in clarifying things).
Check out the word from Microsoft for the proper steps: http://social.msdn.microsoft.com/Forums/en/vssetup/thread/6a569376-4207-4184-a8a7-73d5168c787e Just follow the directions there and you should have no problem getting it to install.
This is more oriented for VS with SQL, but just replace the related steps with doing the steps within the SQL installer basically.