IIS 7 and Above
ApplicationPoolIdentity + SQL
Last post Aug 30, 2011 01:11 AM by harpreet81
Nov 09, 2009 10:01 AM|foxontherock|LINK
Application Pool Identity
Nov 11, 2009 04:35 AM|Leo Tang - MSFT|LINK
Thanks for share!
If SQL Sever installed on another machine which is joined to a domain, then ApplicationPoolIdentity use the server's machine account to access SQL Server Database.
Below are some more information, hope help others too.
Application Pool Identities
Jan 22, 2010 02:06 PM|balak|LINK
I had no luck in trying to create a login for the "IIS Apppool\mydefaultool)".
Does this virtual account(Application pool identity) can be used to access the DB hosted on remote sql server? if so how as i am not able to create a login for this account.
Please let me know if you any pointers on this
Please let me know if you have any pointers on this
Jan 28, 2011 04:26 PM|haldiggs|LINK
Thanks for reporting this. I'm on 2008 sever and had no access to this account. You saved me.
May 23, 2011 12:27 AM|SvenAelterman|LINK
I realize this is an old thread, but I was able to use the Management Studio with Denali CTP 1 to create this user account.
Aug 28, 2011 02:54 AM|stephena55|LINK
Aug 28, 2011 10:23 AM|foxontherock|LINK
Aug 30, 2011 01:11 AM|harpreet81|LINK
You need to use Domain\MachineName$ account, It cleary says:
The good news is that Application Pool identities also use the machine account to access network resources. No changes are required.