Download SQL Server Enterprise Manager? (Or the equivalent of Windows 7?)

Question

I support several older sites running SQL Server 2000 and 2005. In my old XP window, I used SQL Server Enterprise Manager to access them.

Now I am in the Windows 7 window. Is this product still available for download / installation and will it work on Windows 7? I can't seem to find a download for this particular component.

Or is there an alternative for Windows 7? I tried installing SQL Server 2008 Manager Express, but it crashed halfway in Windows 7. I have XP running in Virtual Box, so it would be possible using Enterprise Manager if I could figure out where to install it.

Answer 1

Enterprise Manager only supports SQL 2000 server. You cannot use it to access sql 2005 server. Instead, you need Sql Server Management Studio. You can download the express version here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796

I run both a management studio and windows 7 just fine.

As for the enterprise manager, he was never available for download. You should have installed it from the environment that comes with the sql server. Similarly, if you need a non-express version of the management studio, you need to install it when you run the installation for the SQL server.