SQL 2005 Tools / Management Studio

With Microsoft SQL Server 2000, the tools could be installed by running setup on the SQL Server 2000 CD. In SQL Server 2005, things appear to have changed. At least, they did for me. You can install the tools via the installation on the DVD, but each time I tried it would error out with the following:



After searching google and not finding what I was looking for "Just how the heck am I suppose to install the SQL 2005 Tools?" I found this bit of information after delving deep into Microsoft.com's SQL section: The tools come with SQL 2005 Express w/ Advanced Tools.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

Install Microsoft SQL Server 2005 Express Edition with Advanced Services
In addition to the features of SQL Server Express, certain additional capabilities are also available as part of Microsoft SQL Server 2005 Express Edition with Advanced Services (SQL Server Express). SQL Server Express with Advanced Services contains the following features:
SQL Server Management Studio Express, a graphical management tool based on SQL Server Management Studio that makes it easy to manage and administer SQL Server Express databases.

Reporting Services, an integrated report creation and design environment to create reports.
Full-Text Search, a powerful search engine for searching text-intensive data.
Download (234 MB)