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/

2.3 Install and Uninstall Toad Plug-In

Launch SsmsInstallation.exe from the Windows command prompt as administrator.

1. Open SSMS Installation directory (<Toad install directory>/ SSMS Installation) from the
   Windows command prompt.

2. Enter the following:
   SsmsInstallation.exe [Type of Product/Mode] "[TSS Installation Directory]"
   Where:
   [Type of Product/Mode] can be Uninstall, Freeware, Beta, Commercial, Trial
   [TSS Installation Directory] is the directory where Toad for SQL Server resides.
   Example:
   C:\Program Files (x86)\Quest Software\Toad for SQL Server 6.8\SSMSInstallation \SsmsInstallation.exe Commercial "C:\Program Files (x86)\QuestSoftware\Toad for SQL Server 6.8"

3.1 Activate License Key- TOAD For SQL Server

To activate a purchased commercial license

1. Select Help | Licensing from the menu (ALT+H+L)

2. Review the following for additional information

3.2 Upgrade Toad

• Manual Upgrade Toad

  1. Run Toad installer from the downloaded file.

  2. Select the products you want to install and click Install.

If you are upgrading from a previous version of Toad, you are prompted to migrate your settings the
first time you start Toad. The settings files include database connections, layout customizations,
shortcut keys, and options customized in the Options pages.

To migrate the settings again, remove or rename the current version's Application Data folder and
migrate the files from the previous version's Application Data folder.

• Upgrade Automation Scripts to Newer Version of Toad
  An automation script is compatible with the version of Toad in which the script was created. If you want to open and/or modify a script using a newer version of Toad, you must upgrade the script. Toad automatically prompts to upgrade the script the first time you open it in the newer version.
  To upgrade an Automation script :
  1. Open the script in Toad. Toad prompts you to upgrade the script.
  

  

  
  2. To upgrade the script, select Yes.

3. Select No (and do not elect to save the script), to keep the script compatible with the previous
version.
4. If you selected Yes, Toad upgrades your script and saves a backup copy of the original script in the
following location:
<application data directory>\Automation\bak
5. If the script you upgraded is also scheduled, you must migrate the scheduling task, otherwise the
upgraded script will fail to run.

4.1 Move License to another computer

To move the Toad application and license from one user to another user on a different computer.

1. Launch Toad on the old computer.

2. Select Help | Register Toad.

3. Copy the authorization string and site message. (Case sensitive).

4. Install Toad on the new computer

5. Launch Toad on the new computer and it will prompt for registration.

6. Type in the authorization string and site message noted in Step 3 above.

7. Uninstall Toad from the old computer.

4.2 Uninstall Toad for SQL Server

If you uninstall Toad, it may not uninstall completely. When you use Toad, you create new files such as SQL scripts, data output, or temp files, etc. The following types of files are not removed when you uninstall:

• Any new files you create

• Any copies of files you make for backup purposes

• Settings files

Can uninstall Toad for SQL Server by using the Windows install/uninstall programs feature.

To uninstall Toad

1. Open the Windows Control Panel and select Programs and Features|Add/Remove Programs.

2. Select the product that you want to uninstall.

3. Click Uninstall.