Before configuring the Debugger, verify that the following prerequisites have been met:
Check your security policy because it may include an access lock to the remote server.
Notes:
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 |
SQL Server 2008 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 |
SQL Server 2005 Platforms Tested for Debugging | ||||||
Client |
Server | |||||
---|---|---|---|---|---|---|
2003 EE (SP1) |
2000 (SP4) |
2000 Pro (SP4) |
Vista |
Server 2008 | 7 | |
2003 EE (SP1) |
|
|
|
|
||
Vista |
|
|
|
|
||
Server 2008 | ||||||
7 |
SQL Server 2000 (SP4) Platforms Tested for Debugging | ||||||
Client |
Server | |||||
---|---|---|---|---|---|---|
2003 EE (SP1) |
2000 (SP4) |
2000 Pro (SP4) |
Vista |
Server 2008 | 7 | |
2003 EE (SP1) |
|
|
|
|
||
Vista |
|
|
|
|
||
Server 2008 | ||||||
7 |
To debug locally, perform the following 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
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.
To debug locally, perform the following 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
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.
To debug locally, perform the following 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
Copy and register the ssdebugps.dll (debugging host component) on both the client and server. This file is located by default in the following directory on the server where SQL Server 2005 is installed:
C:\Program Files\ Common Files\Microsoft Shared\SQL Debugging
To register this file, open a command prompt and enter the following command:
regsvr32 ssdebugps.dll
Note: If you are unable to locate this file, you can run the remote debugging setup component (rdbgsetup.exe). This file is located by default in the following directory on the server where SQL Server 2005 is installed:
C:\Program Files\Microsoft SQL Server\90\Shared\1033
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.
To debug locally, perform the following 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
Copy and register the sqldbg.dll and sqldbreg2.exe (debugging host components) on both the Toad client and server. These files are located by default in the following directory on the server where SQL Server 2000 is installed:
C:\Program Files\Common Files\Microsoft Shared\SQL Debugging
To register these files, open a command prompt and enter the following commands:
regsvr32 sqldbg.dlls
qldbreg2.exe /RegServer
Note: The Remote Procedure Call (RPC) service should be started on both the Toad client and server.
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.
Under Access Permissions, click Edit Default, and verify permissions.
Note: By default, Windows administrators on a computer running SQL Server are SQL Server sysadmins on that computer.
If autocommit is disabled, commit or rollback the connection in Toad before starting the debugging session.
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. |
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center