...
- Microsoft .NET Framework version 24.08
- MDAC 2.8 or later
- Windows Installer 3.1 or later
...
A typical installation sets up all SQL Defrag Manager components on the same computer. The following table lists the requirements for a typical installation.
| Type | Requirement |
|---|
| CPU | 2 GHz |
| Memory | 2 GB |
| Hard disk space | 30 GB for the Repository |
| Operating system | One of the following operating systems: |
2000 Server SP4 or later- Server 2008 R2 SP1
Windows Server
|
2003 SP1 or later Vista Enterprise or Business 7Server 2016 - Windows Server
|
2008 2008 R2- 2022
Windows 7 SP1+ Windows 8 Windows 10 - Windows 11
|
Microsoft SQL Server (Repository) | One of the following versions of Microsoft SQL Server: |
Microsoft SQL Server 2000 Standard Edition SP4 or laterMicrosoft SQL Server 2000 Enterprise Edition- SQL Server 2005 Standard or Enterprise
- SQL Server 2008 R2 Standard or Enterprise
- SQL Server 2012
|
Microsoft SQL Server 2005 Microsoft 2005 SP2 or later on Vista- 2014 Standard or Enterprise
- SQL Server 2016
|
Microsoft SQL Server 2008 Microsoft SQL Server 2008 R2 - SQL Server 2017 Standard or Enterprise
|
Microsoft SQL Server 2012 - for Windows and Linux
- SQL Server 2019 Standard or Enterprise
|
- for Windows and Linux
- SQL Server 2022
|
Microsoft SQL Server 2014 - Standard or Enterprise for Windows and Linux
|
Microsoft SQL Server (Managed Server) | One of the following versions of Microsoft SQL Server: |
Microsoft - SQL Server 2000 Standard or Enterprise
|
Microsoft - SQL Server 2005 Standard or Enterprise
|
Microsoft - SQL Server 2008 R2 Standard or Enterprise
|
Microsoft 2008 R2 - 2012 Standard or Enterprise
|
Microsoft SQL Server 2012 - SQL Server 2014 Standard or Enterprise
- SQL Server 2016 Standard or Enterprise
- SQL Server 2017 Standard or Enterprise for Windows and Linux
- SQL Server 2019 Standard or Enterprise
|
Microsoft SQL Server 2014 Standard or Enterprise- for Windows and Linux
- SQL Server 2022 Standard or Enterprise for Windows and Linux
|
| Note |
|---|
SQL Defrag Manager now supports Azure. SQL Defrag supports any IaaS deployments for all the SQL versions mentioned above. |
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.
| Type | Requirement |
|---|
| CPU | 2 GHz |
| Memory | 2 GB |
| Operating system | One of the following operating systems: |
2000 Server SP4 or laterServer 2008 R2 Windows Server 2012 Windows Server 2012 R2 Windows Server 2016 Windows 7 Windows 8 Windows 10 - Windows 11
|
Windows Server 2003 SP1 or laterWindows Vista (Enterprise or Business)Windows XP SP2Management 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.
| Type | Requirement |
|---|
| Windows permissions | Local Administrator permissions on the computer hosting the Management Service. |
| SQL Server privileges | A member of the sysadmin fixed server role in the SQL Server instance hosting the Repository and on each managed SQL Server instance. |
Need more help? Search the Idera Customer Support Portal
...
| Ports | SQL Defrag Manager service uses port TCP 5280. |