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

visual studio sgen.exe exited with code 1

While building a project or solution, if  you get the error like: “sgen.exe” exited with code 1, then the most probable reason is because you have a different version of the same project’s DLL in the GAC.
Solution:

1. Open the GAC (C:\Windows\Assembly), find the DLL corresponding to your project.
2. Right click on it and select uninstall

Now re-build your project and the problem must be gone.