asked on

How do I install SQL Server 2005 Management Studio on Windows 7?

There do not appear to be any options when installing SQL 2005 on Windows 7 for installing the Management Studio Tools. I am running SQL 2005 SP3 which appears to be required for Windows 7.

ASKER CERTIFIED SOLUTION

indianguru2

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

blandyuk

May I suggest you install SQL Server 2008 as the management studio is more up-to-date:

http://www.microsoft.com/Sqlserver/2008/en/us/express.aspx

mariraju

Hello there,

SQL 2005 SP3 seems to be fine.
But, what version of SQL server did you install? Did you install SQL 2005 express edition OR any other editions.
If you have installed SQL express you will not see any option for SSMS, which will have to be installed seperately.
You can install either 2005 OR 2008 SSMS. 2008 will provide more functionalities. If you are only looking for SQL 2005 for the version 9.00.4053.00, you should just try SQL 2005 SSMS.

You can download them from here
FOR 2005 SSMS
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en

FOR 2008 SSMS
http://www.microsoft.com/downloads/details.aspx?FamilyID=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en

One more thing, also make sure to download the compatible version(32-bit or 64-bit)

Please do let me know the outcome.

Cheers