Hi chetan,
Step 1 : Expand the Security
Step 2 : Right click of Logins
Step 3 : Select New Login
Step 4 : Enter your windows user name (User name should be Domain\User Name)
Step 5 : Go to Server roles -> Select Public
Step 6: Go to User Mappings and select Database (Which database against you want to debug)
Step 7 : Assign role member ship as Public and DYNGRP
Step 8 : Select OK
Now try to debug it will work.