July 24, 2015 at 2:06 pm
Hi, I'm trying to use the debugger within SSMS but when I hit the green arrow in the IDE, SSMS pops up the following dialog:
https://www.dropbox.com/s/m67j4izonr9d4s6/debug%20sql%20server.png?dl=0
When I go to the database server and type firewall.cpl, the opened window has a red alert on top that says "Your computer is not protected: turn on Windows Firewall." Therefore, it seems that the firewall would not be preventing SS debugging because the firewall is not turned on.
The second part of the SS degug dialog says "Make sure you are using a login that is a member of the sysadmin fixed server role." I executed the following SQL in SSMS on the db server:
sp_addsrvrolemember 'corp\myuserid', 'sysadmin'
I also executed the following SQL in SSMS on the db server:
sp_addsrvrolemember 'mysqlloginuserid', 'sysadmin'
Then I restarted my local SSMS that was connected to the server. However, I still get the same error dialog. Any idea what the problem might be, what might be missing or how to debug this configuration?
July 27, 2015 at 2:09 pm
any idea why this might not be working?
July 27, 2015 at 5:13 pm
I ended up debugging through SSMS directly on the DB server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
