hi,
i get the following error when testing the ch2 insertion :
Cannot open database "OneAfrik" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
how do i setup the connection. i don't know where the code takes the user above. where can i change it?
thx, Georges

I has the same trouble in these chapter.

I found two ways to solve it.

Solution 1. Change the connectionstring to one that contain a user and a password. I mean, don't use the Windows Account. (this is the easiest way, but i prefer the other one).

Solution 2. These have some steps.

1. Change the Web.config. Open the web.config and look for the <authentication mode="Windows" /> declaration. And uncomment it or set it (must be inside <system.web> tags).
2. Change the IIS authentication properties. Go to Start>Control Panel > Administrative Tools (or something like that, my windows is a spanish version) > Internet Information Server Manager (IIS) (or something like that you must know how).
   In the IIS Manager, select the PaidTimeOffUI Application from Sites (in the left), and in the middle panel, scroll down and search for Authentification, double click it, and disable the anonymous Authentification, but enable the Basic Authentification or Windows Authentification.
3. Use your Windows Account. When you try to load the application in the browser, it should ask you for an account and a password. You should use your Windows User (like PCName/UserName), and your password. If your computer don't have a login password, I encourage you to enable it.
   
   I hope my bad english don't confuse you more.
   

just to say the step one is optional.