run visual studio as a different user to have debugging permissions

i added the user to the "administrators" group and the "Debugger Users".  I running VS as this user (resource account) so security wasn't a concern. 

If there was a way to configure a connection string as a Active Directory user and not a sql local user login i would have done it that way.

attach to a VS debugger via a different user

here is how you can run your code through the debugger using a different user
http://social.msdn.microsoft.com/Forums/en/vsdebug/thread/eeba26cb-2336-4a80-99f4-ca4167d0758c