...
- 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: - Windows Server 2008 R2 SP1
Windows Server 2012 Windows
|
2000 SP4 or later 2003 SP1 or later Vista Enterprise or Business- Server 2019
Windows 7 SP1+ Windows
|
Server 2008 Server 2008 R2 |
Microsoft SQL Server (Repository) | One of the following versions of Microsoft SQL Server: |
2000 Edition SP4 laterSQL Server 2000 Edition 2005 - 2008 R2 Standard or Enterprise
- SQL Server
|
2005 SP2 or later on VistaSQL Server 2008 - 2012 Standard or Enterprise
- SQL Server
|
2008 R2 - 2014 Standard or Enterprise
|
SQL Server 2012 - SQL Server 2016 Standard or Enterprise
|
SQL Server 2014 - SQL Server 2017 Standard or Enterprise for Windows and Linux
- SQL Server
|
2016 - 2019 Standard or Enterprise
|
(Experimental Support only) |
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 R2 Standard or Enterprise
- SQL Server
|
2008 R2 - 2012 Standard or Enterprise
- SQL Server
|
2012 - 2014 Standard or Enterprise
- SQL Server 2016 Standard or Enterprise
|
SQL Server 2014 - SQL Server 2017 Standard or Enterprise for Windows and Linux
- SQL Server
|
2016 - 2019 Standard or Enterprise
|
(Experimental Support only) 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: Windows Server 2008 R2 Windows Server 2012 Windows
|
2000 SP4 or later 2003 SP1 or laterWindows Vista (Enterprise or Business)Windows XP SP22016 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.
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. |