SQL Debugging: Security Issues
Visual Studio 2005
This topic applies to:
| Visual Studio Edition | Visual Basic | C# | C++ | J# | Visual Web Developer |
| Express | No | No | No | No | No |
| Standard | No | No | No | No | No |
| Pro/Team | Yes | Yes | Yes | Yes | Yes |
SQL debugging uses DCOM to communicate between server and client. You need appropriate permissions to be able to debug against the SQL Server. If you get a message box saying that security has not been set up correctly on a server, check for the following:
-
Proper access privileges on the machine running SQL server. For more information, see Configuring DCOM for SQL Debugging.