CODEWITHSUNDEEP
c#sqlvisual-studiovisual-studio-2008
Rod
Rod

Reputation: 15455

trying to attach to a process in debug

I'm in VS2008 trying to Attach to a process... I can attach fine to the Managed Code, however I get an error when trying to attach to T-SQL it says Access is denied.

How do i resolve that?

Upvotes: 1

Views: 132

Answers (2)

Conrad Frix
Conrad Frix

Reputation: 52655

T-SQL debugging from Visual Studio has a lot of requirements on the server and the client you should review the following the MSDN Documents

Debugging SQL

Setting Up SQL Debugging

SQL Debugging Setup Errors and Troubleshooting

And in particular since you have Access issues

SQL Debugging: Security Issues

How to: Set SQL Server Permissions for Debugging

Upvotes: 1

E. Rodriguez
E. Rodriguez

Reputation: 717

Are you debugging locally or on a remote database? If remote, is the user whose context you are debugging in configured as a login in SQL Server?

If it isn't, you will have to run your debugger with an authorized Windows user.

Upvotes: 1

Related Questions