View Single Post
  #20 (permalink)  
Old September 3rd, 2013, 12:13 AM
maurices5000 maurices5000 is offline
Authorized User
Points: 94, Level: 1
Points: 94, Level: 1 Points: 94, Level: 1 Points: 94, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Aug 2013
Posts: 24
Thanks: 7
Thanked 0 Times in 0 Posts

Guys! Its working.

Thanks A MILLION!!!!!

I was typing the below beforehand. I'll keep it for future reference. The Test Setting button in IIS Basic Setting still fails. But when i run the app now in VS2010, it works like its supposed to. I hope I'm not deceiving myself. Could it be running off VS Development Server?

Ok What I've done is I added both IIS APPPOOL\ASP.NET v4.0 and IIS APPPOOL\DefaultAppPool to the SQL SERVER's Security Logins. The Book author's aspnet.sql script had already added them to the AdventureWorks database.

I added them both to the file permissions at C:\inetpub\wwwroot, giving them full access.

I clicked the Advanced button at the bottom of the Security tab. Clicked Change Permissions and clicked the checkbox that says Replace All Child Object Permissions check box. ((It did not stay checked however).