Remote Transact-SQL Debugging on Windows Vista

This topic applies to:

Visual Studio Ultimate

Visual Studio Premium

Visual Studio Professional

Visual Studio Express

Bb157686.DoesApplybmp(en-us,VS.100).gif Bb157686.DoesApplybmp(en-us,VS.100).gif Bb157686.DoesApplybmp(en-us,VS.100).gif Bb157686.DoesNotApplybmp(en-us,VS.100).gif

When you do Transact-SQL debugging or Transact-SQL application debugging against a remote instance of SQL Server, Visual Studio must configure the Windows Firewall before remote debugging can begin. Normally, this configuration occurs when you try to step into a Transact-SQL stored procedure on a remote computer.

On Windows XP, the Windows Firewall configuration starts automatically. On Windows Vista, the new security model requires that you grant permission before the software can configure the Firewall. As a result, a Visual Studio dialog box appears, informing you that the Firewall has to be configured, followed by the Windows Vista User Access Control (UAC) dialog box. If you grant permission in the UAC dialog box, the Configure Firewall for Remote Debugging wizard appears.

See Also

Other Resources

Setting Up Transact-SQL Debugging

The Windows Vista Security Model

How to: Set Up Remote Debugging