Second this. I have 2 sets of Windows credentials at my job as well - one for my normal work, and elevated creds for DevOps-y stuff. I can log into the node in question directly with my elevated creds, and then run SSMS from there, but then I miss out on the LINQPad-y goodness that I have come to know and love.
Although, gotta say, I did NOT know about the Run As option. That's slick, even if it is a bit of a PITA.
Second this. I have 2 sets of Windows credentials at my job as well - one for my normal work, and elevated creds for DevOps-y stuff. I can log into the node in question directly with my elevated creds, and then run SSMS from there, but then I miss out on the LINQPad-y goodness that I have come to know and love.
Although, gotta say, I did NOT know about the Run As option. That's slick, even if it is a bit of a PITA.