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?
Asked
Active
Viewed 4.9k times
6
-
Which version of SQL Mgmt Studio? I have installed SQL 2008 mgmt studio on Windows 7 32bit/64bit. – Darrel Miller Jan 30 '10 at 04:18
-
1you'd help yourself if you described the error.... – Mitch Wheat Jan 30 '10 at 04:19
-
2Sql Management studio is also a tool used by developers to do dev work. – Darrel Miller Jan 30 '10 at 04:19
-
@Darrel: if he were asking how to use SQL Management Studio to do dev work, I'd agree. – John Saunders Jan 30 '10 at 04:24
-
@john Those questions will be coming next, once he has figured out how to install it ;-) – Darrel Miller Jan 30 '10 at 04:37
7 Answers
3
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.
0
You must install it as administrator. It's not enough to be logged in to the administrator account. You must all right-click on the installer file and choose the "Run as Administrator" option.
Joel Coel
- 12,932
- 14
- 62
- 100
0
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!
Ricardo Sanchez
- 195
- 1
- 6
-
Just to let you know, the Express version of Management Studio is a different product. It is a stripped down version of what is included with the full versions of SQLServer. – Joe Internet Feb 11 '10 at 00:28
-
@Joe Thanks, I am aware of that and I am glad you posted this comment so everyone else is aware of it too :) – Ricardo Sanchez Mar 23 '10 at 15:12
0
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).
Richard
- 5,324
- 1
- 23
- 20
0
You could try installing through the Web Platform Installer. I just used the tool to install SQL 2008 and Management Studio, without any issues.
Grant Palin
- 342
- 2
- 3
- 18
0
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.
tcnolan
- 432
- 2
- 12
0
you just need to use the 32bit version on win7 (It's under options in the first window of the setup of sql server). While the 64bit versions rule checks fail. It works just fine with the 32bit version.
Hope this helps.