Configure SQL Server Debugging
Debugging Prerequisites
Before configuring the Debugger, verify that the following prerequisites have been met:
- Disable all firewalls or open corresponding ports. Specifically, the TCP 135 port must be opened and the Toad.exe must be added to the Exceptions list. The same is true for the remote (SQL Server) machine - TCP 135 port must be opened and sqlservr.exe must be added to the Exceptions list.
- Stop any antivirus software that can lock the corresponding components, settings, etc.
-
Check your security policy because it may include an access lock to the remote server.
Notes:
- The security policy can be applied to the domain or local computer.
- Currently, you cannot debug CLR stored procedures.
The following platforms have been tested for debugging support.
Note: The Service Pack on the client must match the Service Pack on the server unless specified otherwise.
|
SQL Server 2012 and SQL Server 2014 Platforms Tested for Debugging | ||||||
|
Client |
Server | |||||
|---|---|---|---|---|---|---|
|
2003 EE (SP2) |
2000 (SP4) |
2000 Pro (SP4) |
Vista |
Server 2008 | 7 | |
|
2003 EE (SP1) |
|
|
|
|
 |
|
|
Vista |
|
|
|
|
|
|
| Server 2008 | |
|
|
|
|
|
| 7 | |
|
|
|
 |
|
Configure Debugging for SQL Server 2012 / SQL Server 2014
To debug locally, perform the following on the Toad client
- Install the appropriate SQL Server Client Tools (2012 /2014) on the Toad client.
-
If autocommit is disabled, commit or rollback the connection in Toad before starting the debugging session.
To debug remotely, perform the following
- Install the appropriate SQL Server Client Tools (2012 /2014) on the Toad client.
-
Set the following permission. Your server login must also be a member of the sysadmin role. This login can be your Windows user account (Windows authentication), or a SQL Server login (SQL Server authentication).
To create a server login from your Windows account and add it to the sysadmin role, a user who already has sysadmin privileges must execute the following:
sp_addsrvrolemember 'Domain\Name', 'sysadmin'
where Domain\Name is your Windows login.
-
If autocommit is disabled, commit or rollback the connection in Toad before starting the debugging session.
Set Up Debugging
The Debugger Setup wizard checks your database library and settings files on both the server and client system to identify conflicts with the Debugger.
The wizard verifies the following on the server:
-
Existence of the corresponding DLL files
-
DLL version (determines whether Toad has permission for their verification)
-
COM registration
-
DCOM support
The wizard verifies the following on the client:
-
Existence of the corresponding DLL files
-
DLL version
-
COM registration
-
Availability of DLLs for this user
-
Ability to connect to the server
-
Whether this user has administrator privileges for the server
-
DCOM support
To run the Debugger Setup wizard
| » | Select Debug | Debugger Setup Wizard from the menu in an open Editor window. |