Considerations for Installing SQL Server Management Tools

SQL Server Setup

SQL Server Management tools include the following components:

  • SQL Server Management Studio
  • SQL Server Profiler
  • SQL Server Database Tuning Advisor
  • Command prompt tools, such as sqlcmd.exe and osql.exe.
  • Business Intelligence Development Studio add-ins to Microsoft Visual Studio

Note that Business Intelligence Development Studio is a separate option during SQL Server installation.

Regardless of how many instances of SQL Server, Analysis Services, or Reporting Services are installed on a computer, only one copy of SQL Server 2008 Management Tools will be installed.

SQL Server 2008 Management Tools can run side-by-side on the same computer with earlier versions of SQL Server Management Tools.

See Also