How to set up IIS 7.5 to use an Apppool user to connect to Sqlserver
Honor those who should.
Setting up a new Web site and then connecting it to Sqlserver is a breeze if one uses the development web server.
But if one wants to use the real McCoy, i.e. IIS, there is more work.
iis apppool: http://www.selfelected.com/iis-7-iisapppool-lightly-explained/
Why use the real IIS when it is so cumbersome? Because it looks more like the real production environment.
How do I debug? Like this:
Start Visual studio i in administrator mode. (if one doesn’t, VS is helpful with this)
Then ctrl-alt-p (menu:debug:attach to process) and choose the w3wp.exe process, with the right user name. Attach. Debug.
