Login failed for user NT AUTHORITY NETWORK SERVICE

Question

I been strugling with this for 2 days now without comming any closer to solution  I have read 20-30 threads alteast and stil can not resolve this   Please help me out   I have disable anonymous authentication  enable asp net impersonation   I have added  lt identity impersonate    true    gt   I have added the a user to the security logins that is connected to the database I try to connect to  This is the connectionstring I use   Data Source IPTOSERVER Initial Catalog Phaeton User Id User Password Password    errormessage      Cannot open database  Phaeton mdf  requested by the login  The login failed       Login failed for user  NT AUTHORITY NETWORK SERVICE

User · Answer

The Best way is to create a user for your application and assign the permissions that are suitable for that user  Dont use  NT AUTHORITY NETWORK SERVICE  as your user it has its own vulnerability and it is a user that has permissions to so many things on the OS level  Stay away from this built in user

User · Answer

The error message you are receiving is telling you that the application failed to connect to the sqlexpress db  and not sql server  I will just change the name of the db in sql server and then update the connectionstring accordingly and try it again   Your error message states the following   Cannot open database  Phaeton mdf  requested by the login  The login failed    It looks to me you are still trying to connect to the file based database  the name  Phaeton mdf  does not match with your new sql database name  Phaeton    Hope this helps

User · Answer

If the error message is just       Login failed for user  NT AUTHORITY NETWORK SERVICE      then grant   the login permission for  NT AUTHORITY NETWORK SERVICE    by using    sp grantlogin  NT AUTHORITY NETWORK SERVICE      else if the error message is like       Cannot open database  Phaeton mdf  requested by the login  The login   failed  Login failed for user  NT AUTHORITY NETWORK SERVICE      try using    EXEC sp grantdbaccess  NT AUTHORITY NETWORK SERVICE      under your  Phaeton  database

User · Answer

Make sure that the database is created  I got the same error when I applied the migration to the wrong project in the solution  When I applied the migration to the right project  it created the database and that solved the error

User · Answer

I was experiencing a similar error message that I noticed in the Windows Event Viewer that read      Login failed for user  NT AUTHORITY NETWORK SERVICE   Reason  Failed to open the explicitly specified database   CLIENT  local machine    The solution that resolved my problem was    Login to SqlExpress via SQL Server Management Studio Go to the  Security  directory of the database  Right-click the Users directory Select  New User     Add  NT AUTHORITY NETWORK SERVICE  as a new user In the Data Role Membership area  select db owner Click OK   Here s a screenshot of the above

User · Answer

I am using Entity Framework to repupulate my database  and the users gets overridden each time I generate my database   Now I run this each time I load a new DBContext   cnt Database ExecuteSqlCommand  EXEC sp addrolemember  db owner    NT AUTHORITY  NETWORK SERVICE

User · Answer

The SQL Server login required is DOMAIN machinename   This is the how the calling NT AUTHORITY NETWORK SERVICE appears to SQL Server  and file servers etc   In SQL    CREATE LOGIN  XYZ Gandalf   FROM WINDOWS

User · Answer

You said it worked fine when you were using SQL Express edition  By default express editions create a named instance  amp  run in NT Authority Network Service   SQL Server STD by default install a default instance  amp  run in NT Authority SYSTEM   Do you have both the full SQL edition  amp  Express edition installed on the same machine    It could be that somewhere the connection string still refers to the Named instance  SQLEXPRESS  rather than the default instance created by the full version  Also where is the connection string defined  In IIS or your code  Make sure that if defined in many places  all point to same SQL instance  amp  database  Also try looking at the detailed error present in the SQL Server error logs  The error logged in event log are not complete for secuirty reasons  This will also help you to know if the connection was made to the correct SQL Server  Also make sure that the machine on which SQL is installed is accessible  amp  IIS is trying to access the same machine  In my company sometimes due to wrong name resolution  the query fails since most of our computers have SQL installed  amp  the query lands in the wrong SQL Server  Make sure that the database exists in the SQL Server  The name displayed under databases in SQL Management Studio should match that in the connection string

User · Answer

I liked Jed s solution but the issue with that was every time I built my project in debug mode  it would deploy my database project and removed the user again  so I added this MySQL script to the Post-Deployment script   it practically does what Jed said but creates the user every time I deploy   CREATE USER  NT AUTHORITY NETWORK SERVICE      FOR LOGIN  NT AUTHORITY NETWORK SERVICE      WITH DEFAULT SCHEMA   dbo  Go  EXEC sp addrolemember  db owner    NT AUTHORITY NETWORK SERVICE

[asp.net] Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

Examples related to asp.net

Examples related to sql-server-2008

Examples related to iis-7

Examples related to web-config

Examples related to connection-string