Hi all,
I can reproduce this consistently, can anyone else reproduce (and if you can explain why it is so - if not suggest where I'm going wrong)?
IIS 7.5 and 8.0 express and full
SQL 2008 R2
website - mvc 5 but that shouldn't matter
database with no permission for "DOMAIN\machine$"
open IE - run the site - "Login failed for user 'DOMAIN\MACHINE$'.
leave IE open
add login for DOMAIN\MACHINE$ to SQL server and DB
press f5 in IE => same error
close ie, reopen - run site => same error
recycle app pool, now its fine...
it appears that the security context is pooled or cached or something, so the permissions chnages in SQL are not checked after the first connection... is this connection pooling at work?
Had me stumped for 15 mins while I scratched my head why the permissions changes I was making were not having any impact on my app... Go to the complete details ...