I've asked the question because I have different version of MS SQL databases version 2000 and 2005. I normally managed my database in MSSQL Server 2000 using Enterprise Manager tool and I am using SQL Server Management Studio to manage MSSQL Server 2005 database.
The Enterprise Manager is not available for download. You can install the client tools from the CD.
"The Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy to use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services" (Microsoft.com, 2008).
Here's the download link.
How to install Enterprise Manager (client tools) for MS SQL Server.
- Insert your MS SQL Server CD, browse the CD, go to e:\english\SQL2000\ent ; this is what I have in my installation CD.
- Double click on AUTORUN
- Select the SQL Server 2000 components to continue.
- Click on Install Database Server; the install shield will begin.
- In Microsoft SQL Server 2000, click on Next
- Computer Name, select Local Computer then click Next ; I'm using my test computer for this install so I choose local computer.
- In Installation Selection, put check on Create a new instance of SQL Server, or install Client Tools, click on Next.
- In User Information, type your Name and Company, click Next to continue.
- Software License Agreement, click Yes to accept.
- In Installation Definition, select Client Tools Only, click Next.
- Select Components, I select Management Tools, Client Connectivity, Books Online, and Development Tools.
- Click Next
- Start Copying Files, click on Next ... setup is preparing to copy files.
- Click on Finish.
To test your Enterprise Manager (client tools) installation, simply run the program. It should be added to your All Programs, Microsoft Server, Enterprise Manager.
How to connect to DB Server?
- When you open your Enterprise Manager (client tools), you don't have anything setup.
- In SQL Server Enterprise Manager, highlight Microsoft SQL Servers, right click and select New SQL Server Group
- In Name, type Testing, click Ok ;I use Testing for my own test only, you can change this ofcourse.
- Select the group Testing (the you just created), right-click and select New SQL Server Registration.
- In Register SQL Server Wizard, click Next
- Select a SQL Server in Available Servers, click Add, then Next
- Select an Authentication Mode, Windows Authentication or The SQL Server login information. I choose the SQL Server login so I can use the built-in sa account for testing.
- Select Connection Option, Login automatically or Prompt. I prefer Prompt for the SQL Server account information when connecting to provide extra security.
- Add the SQL Server to an existing SQL Server group. I created Testing group or you can choose the default SQL Server Group (most db admin do anyway). I create my own group so I can organize DB connection management.
- Completing the Register SQL Server Wizard, click Next, then Close to end.
The installation of Management Studio for SQL Server 2005 should be the same approach. You can't go wrong by accepting default. Visit our Geek community for assistance.