How to configure the debugger in SQL Server 2005 to work with Toad
The previous versions of Toad for SQL Server did not support SQL Server 2005. Applies to Toad for SQL Server version 1.0.1 and 1.0.3.
Please follow the Toad Getting Started Guide document for the steps to setup the debugging environment in SQL Server 2005. This document can be found in this directory: 'C:\Program Files\Quest Software\Toad for SQL Server 2.0'. Alternatively, Toad for SQL Server documentation can be downloaded from SupportLink at http://support.quest.com/support_download/Downloads.asp
Along with that, you will also need to setup your server for 'Local and remote connections'. Here's how to do this:
1. Go to Start | Programs | Microsoft SQL Server 2005 | Configuration Tools | SQL Server 2005 Surface Area Configuration
2. Select the link for 'Surface Area Configuration for Services and Connections'
3. In the 'Surface Area Configuration for Services and Connections' screen, expand 'MSSQLSERVER | Database Engine' and select 'Remote Connections'
4. Make sure that the 'Local and remote connections' and 'Using TCP/IP only' options are selected.
5. Click 'Apply' and 'OK' to accept the changes.
6. Now go to your remote server PC and follow steps 1-5.
