Store procedure debugging in Visual Studio

Question

Hi, I'm trying to debug the stored procedure from Visual Studio 2022.

Unfortunately, I'm not a local administrator since new security measures are preventing users to be admins anymore.

Is it possible to get debugging privileges without being a local admin?

I'm sure this is something that many developers are facing currently or they will be in the very near future.

Answer 1

Hello @Lukic, Dejan,

Welcome to Microsoft Q&A forum.

The admin permissions are necessary. See this document: Requirements for Starting the Debugger

All attempts to start the Transact-SQL debugger must also meet the following requirements:

SQL Server Management Studio or SQL Server Data Tools must be running under a Windows account that is a member of the sysadmin fixed server roll.

The Database Engine Query Editor window must be connected by using either a Windows Authentication or SQL Server Authentication login that is a member of the sysadmin fixed server role.

The Database Engine Query Editor window must be connected to an instance of the Database Engine from SQL Server 2005 (9.x) Service Pack 2 (SP2) or later. You cannot run the debugger when the Query Editor window is connected to an instance that is in single-user mode.

The server needs to communicate back to the client via RPC. The account under which SQL Server service is running must have authenticated permissions to the client.

Sincerely,

Tianyu

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.