MS SQL Server Debugger (Revision #39)

Aqua Data Studio 7 expands enterprise support with the ability to debug SQL Stored Procedures in Microsoft SQL Server 2005/2008. The new debugger provides the same consistent user interface you have come to know with our Oracle and Sybase debuggers. This allows you to use a common debugger across all the databases you interact with, and in fact offers the only way to debug MS SQL Server Stored Procedures when running on non-Windows platforms.

MS SQL Debugger	MS SQL Server Registration Advanced Properties

New Features in the Debugger

• Supports Microsoft SQL Server 2005/2008.
• Breakpoints Tab – Set breakpoints at any line in the Procedure or Function source code to run just the section of the code you are testing.
• Variables Tab – Enter variables and monitor their values during debugging.
• Watches Tab – Enter expressions and watch their values in this tab.
• Console Tab – All outputs are displayed here.
• Step Into to move to the next block of code.
• Step Return to move to the next return of code.
• Step Over to move to the next line of code.
• Stop button to halt the debugger at any time.

Documentation -> MS SQL Debugger

Configuring DCOM security on SQL Server for Aqua Data Studio debugger:

In case granting "administrators" permission is a concern, then :-

• You can create a local user under "Users" group.
• Then go to Control Panel > Administrative Tools > Local Security Policy > Security Settings > Local Policies > Security Options :-
  • Double-click "DCOM: Machine Access Restrictions" policy, click Edit Security, add the user created above, allow "Remote Access"
  • Double-click "DCOM: Machine Launch Restrictions" policy, click Edit Security, add the user created above, allow "Local Launch", "Remote Launch", "Local Activation", "Remote Activation"
  • Double-click "Network Access: Sharing and Security Model for local accounts" policy, and set to Classic"
• Go to Control Panel > Administrative Tools > Component Services > Computers > right-click My Computer > click Properties > click COM Security tab :-
  • In Access Permissions section, click Edit Default > add the user created above, allow "Remote Access"
  • In Launch and Activation Permissions section > click Edit Default > add the user created above, allow "Local Launch", "Remote Launch", "Local Activation", "Remote Activation"
• Disable Windows Firewall or any other Firewall software that would prevent DCOM clients from connecting to the DCOM server.

(You can also go to a specific component in the Component Services section to grant permission, instead of granting permission from "My Computer" which is a blanket grant)

The MS SQL Server debugger uses the Open Source Library j-Interop to communicate with Windows COM to make the debugger possible.

j-Interop: http://www.j-interop.org/