View Single Post
  #1 (permalink)  
Old March 25th, 2007, 10:57 AM
GS GS is offline
Authorized User
 
Join Date: Sep 2003
Location: , , .
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default failed for user 'NT AUTHORITY\NETWORK SERVICE'

All,

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.
G