We have a dev that used to use SSMS in order to debug code that was related to SQL. I guess MS has taken that piece out of SSMS and now they are supposed to do this with Visual Studio. Problem is, now we can't seem to get that to work right.
Each time they try with VS19 to a SQL 2019, the following error comes up:
"Unable to start the Transact-SQL debugger, could not connect to the Database Engine instance '<instance name>'. Make sure you have enabled the debugging firewall exceptions and are using a login that is a member of the sysadmin fixed server role. The RPC server is unavailable."
The firewall is disabled and according to what I have read, the debugging person's account needs to be in the SQL Server's "sysadmin" role. Done that and also made that user the db owner for good measure. FYI, I've tried using domain group and adding them to the group and also just using their individual domain accounts.
Everything I try reaps the same error message.
Please advise.