Management Studio is like Enterprise Manager and Query Analyzer rolled into one. It doesn't really do much (a fancy text editor with some query and table builders - no database engine).
You need an installer for some version of SQL Server 2005, and to select "Client Tools Only" during setup.