Chat now with support
Chat with Support

Toad for SQL Server 6.8 - Installation Guide

Installation

System Requirements

Review the following client and database server requirements for Toad® for SQL Server.

Client Requirements

Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:

Requirement Details

Platform

2 GHz processor (recommended minimum)

Memory

4 GB of RAM minimum, 16 GB recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

104 MB to run Toad

Note: The disk space required may vary based on the edition of Toad selected for installation.

Operating System

Windows Vista® Service Pack 2 (32-bit or 64-bit)

Windows Server® 2008 Service Pack 2 (32-bit or 64-bit)

Windows Server® 2008 R2 Service Pack 1 (64-bit)

Windows Server® 2012

Windows Server® 2012 R2

Windows® 7 (32-bit or 64-bit)

Windows® 8 (32-bit or 64-bit)

Windows® 8.1 (32-bit or 64-bit)

Windows® 10

Important: Toad uses the Microsoft® Distributed Transaction Coordinator (DTC) when opening a SQL file to get Full-Text Search status, but DTC is disabled by default on Windows Vista, Windows Server 2008 and Windows 7. If you are using either operating system, ensure that Network DTC access is enabled on the Toad client. See http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx for more information about enabling DTC access.

.NET Framework

Microsoft® .NET Framework 4.5.1

Additional Requirements

Web Browser

Microsoft® Internet Explorer® 7.0 or later

Screen

Toad supports 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.

http://www.microsoft.com/downloads/details.aspx?FamilyID=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en

Server Requirements

Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:

Requirement Details

Database Server

Limited support of SQL Server® 2000 (Service Pack 3 or later)

Note: The following features are not available:

  • Index Defragmentation
  • Storage Management
  • Performance Monitor
  • Spotlight Essentials Performance Analytics
  • Altering procedures, functions, views in the Editor
  • Version Control

SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express

SQL Server 2008 and SQL Server 2008 Express

SQL Server 2008 R2 and SQL Server 2008 R2 Express

SQL Server 2012 and SQL Server 2012 Express

SQL Server 2014 Enterprise and SQL Server 2014 Express

SQL Server 2016

Notes: 

  • SQL Server Compact Edition is not supported.
  • Storage Management is not available on SQL Server Express.

Cloud Database Service

SQL Azure

Note:  To be able to utilize a majority of Toad functionality, please grant VIEW DEFINITION on the SQL Azure databases you want to work with.

Virtualization Support

Requirement Details
Application Virtualization

Limited testing has been performed for Citrix® XenApp™ 5.0 on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.

Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.

See Install Toad on Citrix® Systems for more information.

Desktop Virtualization (VDI)

Toad has been tested with vWorkspace™ 7.6 running on Windows Server 2008 R2 64-bit.

Note: Toad may work in virtualization environments other than the ones in which it was tested.

User Requirements

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, Vista standard 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.

 

Install Toad

Note: Your 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.

    Note: When installing Toad using Quest Software Installer on Windows 7 64-bit, Program Compatibility Assistant may appear with “This program might not have installed correctly” message. Select This program installed correctly to continue installation.

Specify App Data Directory Location

Toad for SQL Server 6.8 stores settings files in the user's Application Data directory. The default location cannot be modified from within the application. Toad provides two methods to change the default location: by using a Registry setting or by using a command switch in a Toad shortcut.

Use the Registry setting method to change the application data directory from Roaming to Local. Use the command switch method to change the location to any new path.

To change Toad Application Data directory location from Roaming to Local

In the Registry under Toad for SQL Server (Computer\HKEY_CURRENT_USER\Software\Quest Software\Toad for SQL Server\6.8), add LOCALSETTINGS with a value of 1.

See the following table for default (Roaming) and resulting (Local) directory path.

Caution: All current Toad settings will be lost after applying this Registry setting unless you manually copy the settings files from the default location (Roaming directory) to the new location (Local directory). Copy the settings files BEFORE you add the Registry setting and BEFORE opening Toad.

Operating System

Default Location New Location when
LOCALSETTINGS = 1

Windows XP

Windows Server 2003

C:\Documents and Settings\username\ Application Data\Quest Software\Toad for SQL Server 6.8

C:\Documents and Settings\username\ Local settings\Application Data\Quest Software\Toad for SQL Server 6.8

Windows Vista

Windows Server 2008

Windows 7

Windows 8

Windows 10

C:\Users\username\ AppData\Roaming\Quest Software\Toad for SQL Server 6.8

C:\Users\username\ AppData\Local\Quest Software\ Toad for SQL Server 6.8

To change Toad Application Data directory location using a command-line switch

You can override the default Application Data directory by running Toad with the command switch:

Toad.exe --datadir="YourNewDirPath"

To instruct Toad to always use the new directory path, add the command switch and the new directory path to a Toad desktop shortcut. Then use the desktop shortcut when opening Toad.

  1. To add the command switch, right-click the Toad shortcut and select Properties.
  2. Enter the command switch and add the directory path in quotes (replace "YourNewDirPath" with your directory path).
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents