SQL Server Installation : Useful tools

Adding some of the useful tools, and reports for SQL Server Installation.

  1. SQL Server Setup Discovery Report:

The SQL Discovery report can be used to verify the version of SQL Server and the features installed on the computer.

To open the SQL Discover report,

  1. Go to Start, click All Programs.
  2. Select Microsoft SQL Server <Version number>, Configuration Tools, and select SQL Server Installation Center.
  3. Under Tools section, click "Installed SQL Server features discovery report"

Alternatively, this report is stored under the path: %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Log\<last Setup Session>.

Comments

  • Anonymous
    June 06, 2011
    Thanks Chaitanya for pointing a very usefull report !!! Cheers
  • Anonymous
    December 11, 2014
    I work at a company with several SQL Server databases I need to work with, and I need SQL Server Management Studio.     Why does Microsoft make it nearly impossible to download SQL Server Management Studio?     Or, if it is available, it's completely buried within some "SQL Server Express" download.    I don't know what to do.  Thomas Downes(714) 756-0810