View Single Post
  #21 (permalink)  
Old September 3rd, 2013, 01:58 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Ah, that makes perfect sense. Since you're using integrated security and the "apppoolidentity", the code runs under the IIS AppPool account. Granting permissions on disk lets that account access files. Adding it as a login in SQL Server lets it log in to SQL Server and adding it as a user to a database (which you already had), grants it permissions to use that specific database.

Glad it's working!

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote