Quest-TOAD FOR SQL Server

1.1 Client Requirements

• Operating Systems
  - Windows Server@ 2008 R2 SP2
  - Windows Server@ 2012
  - Windows Server@ 2012 R2
  - Windows Server@ 2016
  - Windows Server@ 2019
  - Windows@ 7 SP1 (32-bit or 64-bit)
  - Windows@ 8.1 (32-bit or 64-bit)
  - Windows@ 10, version 1809

• Firewall Requirement
  - Windows Server
  a) Port 135 (WMI) to Destination and WMI Random port 49152 - 65535 to Spotlight Client
  b) Spotlight requires the network setting “File and Print Sharing” to be enable
  - Database Monitor

  a) Database Port

• Hardware Require (Minimum)
  - 2 GHz processor (recommended minimum) Platform
  - 4 GB of RAM minimum, 16 GB recommended Memory

• Hard Disk space : 800 MB to install Toad, 162 MB to run Toad

• Microsoft® .NET Framework 4.7.1

• Browser Require
  - Internet Explorer@ 11 or later

• Supports screen : screen resolutions up to 3200 x 1800 and display DPI settings up to 150%

• Copy/Move Database Wizard
  The SQL Server Backward Compatibility package is required to use the Copy/Move Database wizard.

• Log Reader
  The Log Reader requires version 8.0 DLL files in the Microsoft Visual C++ 2005 SP1 Redistributable Package. If these files do not exist on the client, you will need to install them to use some functionality in the Log Reader.

1.2 Server Requirements

• Database Server
  - SQL Server 2012 and SQL Server 2012 Express
  - SQL Server 2014 Enterprise and SQL Server 2014 Express
  - SQL Server 2016
  - SQL Server 2017

• Cloud Database Service
  - SQL Azure and Azure SQL Data Warehouse

1.3 User Requirements

1. User Requirements to Install Toad

• Only Windows Administrators and Power Users can install Toad.

• If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User—on the computer.

  If a Power User installs Toad, a Restricted User cannot do the following:
  - Associate file extensions.
  - View the Toad shortcut icon on the desktop or the Toad menu options in the Windows Start menu. As a workaround, Restricted Users can create a shortcut to Toad from the install directory and place the shortcut on their desktop.

• User Requirements and Restrictions for Running Toad

  The following describes the requirements and restrictions for users who launch and run Toad:
  - To create or modify the QuestSoftware.ToadSecurity table to enable Toad Security, the user who maintains this table must have privileges to create, insert, update, and delete it. All other users need only the ability to read the QuestSoftware.ToadSecurity table to use Toad Security features.

2.1 Install TOAD for SQL Server

Toad for SQL Server license key determines the edition and will enable Toad for SQL Server functionality accordingly. In many cases, if functionality is disabled within Toad for SQL Server, you may not have an appropriate license to use it. When Toad is running, you can see which components are licensed by selecting Help | About.

To install Toad
1. Run the Installer.
2. Accept the License Agreement.
3. Select the products you want to install and click Install.

2.2 Install Toad SQL Server Silently

Silent installation provides a convenient method for deploying Toad to multiple machines. With some customization, you can also deploy the license key and settings at the same time.

Use a stand-alone installer to perform a silent install. Obtain your installer files at  https://support.quest.com/