Page tree

You can easily and quickly install SQL Defrag Manager on any computer that meets or exceeds the following hardware, software, and permission requirements. Consider the following requirements when installing SQL Defrag Manager in a typical environment.

General product requirements

All SQL Defrag Manager components require the following software:

  • Microsoft .NET Framework version 2.0
  • MDAC 2.8 or later
  • Windows Installer 3.1 or later

Typical installation

A typical installation sets up all SQL Defrag Manager components on the same computer. The following table lists the requirements for a typical installation.

TypeRequirement
CPU2 GHz
Memory2 GB
Hard disk space30 GB for the Repository
Operating system

One of the following operating systems:

  • Windows Server 2003

  • Windows Server 2008

  • Windows Server 2008 R2

  • Windows Server 2012

  • Windows Server 2012 R2

  • Windows Server 2016

  • Windows Vista

  • Windows 7

  • Windows 8

  • Windows 10

Microsoft SQL Server (Repository)

One of the following versions of Microsoft SQL Server:

  • SQL Server 2000 Standard Edition SP4 or later
  • SQL Server 2000 Enterprise Edition
  • SQL Server 2005 Standard or Enterprise
  • SQL Server 2005 SP2 or later on Vista
  • SQL Server 2008 Standard or Enterprise
  • SQL Server 2008 R2 Standard or Enterprise
  • SQL Server 2012 Standard or Enterprise
  • SQL Server 2014 Standard or Enterprise
  • SQL Server 2016 Standard or Enterprise

Microsoft SQL Server (Managed Server)

One of the following versions of Microsoft SQL Server:

  • SQL Server 2000 Standard or Enterprise
  • SQL Server 2005 Standard or Enterprise
  • SQL Server 2008 Standard or Enterprise
  • SQL Server 2008 R2 Standard or Enterprise
  • SQL Server 2012 Standard or Enterprise
  • SQL Server 2014 Standard or Enterprise
  • SQL Server 2016 Standard or Enterprise

Console-only installation

A Console-only installation installs the SQL Defrag Manger Console. The Console-only installation assumes that a full installation already resides on another computer. The following table lists the requirements for a Console-only installation.

TypeRequirement
CPU2 GHz
Memory2 GB
Operating system

One of the following operating systems:

  • Windows Server 2003

  • Windows Server 2008

  • Windows Server 2008 R2

  • Windows Server 2012

  • Windows Server 2012 R2

  • Windows Server 2016

  • Windows Vista

  • Windows 7

  • Windows 8

  • Windows 10

Management Service permission requirements

The Windows user account used by the Management Service requires the following permissions to access the SQL Server instances you want to manage.

TypeRequirement
Windows permissionsLocal Administrator permissions on the computer hosting the Management Service.
SQL Server privilegesA member of the sysadmin fixed server role in the SQL Server instance hosting the Repository and on each managed SQL Server instance.
Ports SQL Defrag Manager service uses port TCP 5280.


Need more help? Search the IDERA Customer Support Portal