failed for user 'NT AUTHORITY\NETWORK SERVICE'
I can run my ASP .net website in Visual Studio2005 no problems. But when I package and deploy the website, onto a server (with the same SQL server database). I recieve the error:
System.Data.SqlClient.SqlException: Cannot open database "DatabaseName" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
As I can access this through code with the same database, I would expect this to work but no.
If anyobody has any ideas that would be appreciated.