Question: I've been given a backup of a production SQL database to begin writing an application against.  

I've got it running as a local instance and using Windows Authentication and I can READ the information, however I cannot figure out how to get IIS to use my Windows Authentication to log into the SQL server when running a local ASP.Net website. 

I don't have the authority on the DB to add users, and I'm getting an error of `System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.` when I try to access a page that reads the database. 

I don't think I will be able to communicate with the DB admin for a while to get him to fix this up for me. Is there anything I can do here?

Answer: 
Your asp code is using the same identity that IIS runs under - the Network Service account. To get it to use your credentials, you can either hard-code them into a connection string or you can use impersonation (see this link: <http://msdn.microsoft.com/en-us/library/aa292118%28VS.71%29.aspx>) 

The gist of the link:
Put this in your web.config file: `<identity impersonate="true" />`

-t.
You need to create an account in SQL Server for the Network Service account,ex via SSMS via the "Security" section, right click on "Logins" and select add. You will be adding a Windows Account, you can then lookup and validate the name "NETWORK SERVICE". Then switch to the "User Mapping" section and grant permission to view your database.

reference : <http://msdn.microsoft.com/en-us/library/ms998320.aspx#paght000015%5Fsqlserver>

2nd Alternative 
If "integrated security=sspi" is there in your connection string than you should: 

1. Turn on integrated auth in IIS
2. Turn on windows auth in asp.net
3. Turn on imerposation in asp.net

Hopefully it will help.