About Connections

Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

You are here: Manage Connections > About Connections

Connection/Navigation Manager

Use the Connection Manager to create and manage database connections.

See Understand Toad Connections for more information about how Toad handles open database connections, document windows, and connection sharing in a Toad session.

To manage connections

In the Connection Manager, use the following toolbar buttons to manage connections:

	Create a new connection. When creating a connection, click Save to save details for the connection without connecting to the database.
	Create a new connection based an existing connection. When creating a connection, click Save to save details for the connection without connecting to the database.
	Connect to the selected connection. When connecting, click Cancel to abort the attempted connection.
	Disconnect from the selected connection. When disconnecting, click Cancel to abort the attempted disconnection.
	View properties for the selected connection.
	Import connections.
	Export Toad connections and saved passwords to an XML file. You can then provide this file to other users.

Configure Connection Options

You can specify options for database connections in the Toad Options dialog.

To configure connection options

Select Tools | Options to open the Options dialog.

To specify one of the following options, select the corresponding page in the Options dialog.

Option Description	Page in Options Dialog
To show/hide the New Connection dialog on startup.	Select Environment \| General
Specify the number of connections that display in the History pane of the New Connection window.	Select Environment \| General
Automatically open a new Query Builder, Editor, or Database Explorer window on new connections.	Select Database \| General

Tips:

(Windows server only) To start, stop, or pause the database services associated with a connection, right-click a connection and select Services. You must have access to the remote registry where the database is installed to use this feature.

To change the current connection, select a connection from the drop-down list on the Connection toolbar.

To organize your connections, you can create groups. You can then execute a script in the Editor against multiple connections in the selected group. See Group Connections for more information.

Right-click a connection and select Connect on Startup to automatically open that connection each time Toad starts.