Learn more about Toad for SQL Server
at Quest.com

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

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Manage Connections > Create New Connections > Create SQL Server and SQL Azure Connections

Create SQL Server and SQL Azure Connections

You can create a new connection, or connect to an existing connection from the Create New Connection window. See Troubleshoot SQL Server Issues for more information about troubleshooting connection issues.

Note: For SQL Azure connections:

You should be granted VIEW DEFINITION for those databases you want to work with.
You must also be given explicit read-access to the master database.
You can login to Windows Azure Platform by selecting Tools | Cloud Computing | SQL Azure Portal and providing your credentials.
Make sure that no Azure firewall rule restricts your IP address from having access to Azure server.

To create a new connection

Review the following for additional information:

Login Tab	Description
Server name	Enter the name of the server to use when connecting. Click to display any servers running SQL Server that are currently active on the network. Notes: For SQL Azure connections, enter InstanceName.database.windows.net in this field. For named instances, enter the MachineName\InstanceName in this field.
Password	Enter the password to use when connecting. Tip: After connecting, you can set a master password to further secure your connection in Tools \| Options\| Environment \| Security.
Category	Select or create a category if you want to color code Editor tabs for a specific connection. This can help differentiate between development and production databases. You can also set an option to color code the Object Explorer pane and object editor windows (Create, Alter, Drop, etc.). See Set Connection Categories for more information. Click here to view a video of this feature.
Encrypt connection	Select this option to enable encryption for the current connection provided that the certificate has been already installed on the server.
Advanced Tab	Description
Network protocol	Select one of the following: Shared Memory TCP/IP Named Pipes Note: When establishing Named Pipes connection "Poll service status in connection list" option should be cleared.

Click Connect to save the connection and immediately connect to the database.

or

Click Save to save the connection without connecting to the database.

Tip: Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.

To connect to server via Central Management Server

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

Notes:

CMS is available on Microsoft SQL Server 2008 only.
User should have an appropriate login (Windows Authentication and grant to connect to selected server are required) created on the server to which he connects via CMS.