Is the SQL Server Enterprise Manager automatically installed on my computer?

No, SQL Server Enterprise Manager is installed as part of the Management Tools for SQL Server 7.0. You must run SQL Server 7.0 Setup and select the Client Connectivity and Management Tools options in order to run this software.