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

Hi there,

Take a look here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Hi,

You should grant access to the 'NT AUTHORITY\NETWORK SERVICE' to do so from the enterprise manager if it is SQL 2000 or from the Management tool if it is 2005, go to your database and from the Security node choose teh Users Node then add new user then select from the general tab the Login name, then browse then check the 'NT AUTHORITY\NETWORK SERVICE'

it supposed to work now.

Thanks for that. I reviewed the document and found it useful.

I have changed both my virtual directory settings and SQL security settings to use Windows Authentication. I there anything I need to do after as I still recieve the same error?

Thanks in advance.
G

this is sql error, it has nothig to do with the virtual Directory or IIS, it is for granting access to the 'NT AUTHORITY\NETWORK SERVICE' which can't loging without adding it to the database logins

Thanks for that - I added in the user and this works now.

Many Thanks
G