Unable to Install SQL 2005 Management Tools with Visual Studio 2005 installed.

  • Article

SQL Server Express Edition 2005 (Express) installs a set of command line tools that it calls Workstation Components, which happens to collide with the Management Tools for the other SQL Server 2005 editions. This presents a problem if you first install Visual Studio 2005 and SQL Server Express 2005 before installing SQL Server 2005 on the same machine. The Workstation Components shipped with Express consist of command line tools only, no SQL Management Studio.

If you already have Express installed and you want to install the full set of Workstation Components from a different edition, such as Developer, you'll first need to remove the Workstation Components from the Control Panel. Once that's done you can install the Workstation Components that include SQL Management Studio.

j.