none
login failed for nt authority\network service RRS feed

  • Question

  • Read all of the related forums and solutions do not work.  IIS6, server 2003, sqlexpress 2008.  ASP.net web app. 


    "cannot open database requested by login.  Login failed for nt authrity\network service

    Webconfig:

    <remove name="LocalSqlServer" />
       
      <add name ="LocalSqlServer" connectionString="server=.\webapps;database=aspnetdb;integrated security=true"/>

    Ive tried modifying the connection string in every possible combination:

    initial catalog, remove 'integrated security', remove user instance,

    sp_grant login 'nt authority\network service' in sql mgmt studio

    go to the database under wwwroot and add nt authortiy\network service in the database's security tab.  (this entry often disappears and I have to re add it again.  I think its because of mgmt studio?)





    Bits of Fury
    Saturday, February 27, 2010 6:10 PM

All replies

  • Hi are you able to login in to the DB using windows authentication?
    Saturday, February 27, 2010 8:25 PM
  • Thanks for replying, I'm not sure exactly what you mean

    Bits of Fury
    Sunday, February 28, 2010 3:41 AM
  • Hi There
    Please try the following

    Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=yourDatbase
    Please mark the post as answered if my post is the answer for your question, and mark other helpful posts as helpful. Thanks Vijay
    Sunday, February 28, 2010 5:40 AM
  • I put that in, and redid the gridview sqldatasource connection string to use that in web.config.  It prompts me to connect to sql server.  Using windows authentication, I get

    a network or instance related error occurred.
    Bits of Fury
    Sunday, February 28, 2010 5:33 PM