DotNet: Yet another login problem

  • sal / 204 / Fri, 27 Mar 2009 22:00:00 GMT / Comments (3)
  • Hello,
    I'm a total asp.net newbie. I'm developing a web app and on my machine I
    login to a sql server just fine using NT Authentication via the connection
    string as:

    Integrated Security=True

    However, when I try to open the .aspx page from another machine I get the
    "Login in failed for user NT Authority\Anonymous Logon

    Can someone tell me why this is happening on my test machine but not on my
    development machine? I'm logged in as myself on both machines and I have
    access to the database as me.

    Thanks for any help
    Steve

  • Keywords:

    login, dotnet, .net

  • http://dotnet.itags.org/dotnet-tech/301/«« Last Thread - Next Thread »»
    1. Hi,
      I think your all queries will be answered in the following URL:
      http://www.devhood.com/messages/message_view-2.aspx?thread_id=72204

      Thanks and Regards,
      manish bafna

      "SAL" wrote:

      > Hello,
      > I'm a total asp.net newbie. I'm developing a web app and on my machine I
      > login to a sql server just fine using NT Authentication via the connection
      > string as:
      > Integrated Security=True
      > However, when I try to open the .aspx page from another machine I get the
      > "Login in failed for user NT Authority\Anonymous Logon
      > Can someone tell me why this is happening on my test machine but not on my
      > development machine? I'm logged in as myself on both machines and I have
      > access to the database as me.
      > Thanks for any help
      > Steve
      >
      >

      manishbafna | Wed, 04 Jun 2008 01:51:00 GMT |

    2. Thank you so much. Apparently, all I had to do was to add the
      Trusted_Connection=True attribute to the connection string. I already had
      the Integrated Security=True attribute but that wasn't enough evidently.
      Unless something else has change between yesterday and this morning, that
      was the trick.

      S

      "Manish Bafna" <ManishBafna...discussions.microsoft.com> wrote in message
      news:83C98994-FEA3-4B6B-91CF-C0F74C5D2480...microsoft.com...[vbcol=seagreen]
      > Hi,
      > I think your all queries will be answered in the following URL:
      > http://www.devhood.com/messages/message_view-2.aspx?thread_id=72204
      > Thanks and Regards,
      > manish bafna
      > "SAL" wrote:

      sal | Wed, 04 Jun 2008 01:52:00 GMT |

    3. Alright, I take it back. It didn't work after all. I'm still getting the
      same "Login in failed for user NT Authority\Anonymous Logon"
      Error.

      I'm trying some of the stuff in this link that you provided but haven't had
      success yet. One question is, how to force a user login?

      S

      "Manish Bafna" <ManishBafna...discussions.microsoft.com> wrote in message
      news:83C98994-FEA3-4B6B-91CF-C0F74C5D2480...microsoft.com...[vbcol=seagreen]
      > Hi,
      > I think your all queries will be answered in the following URL:
      > http://www.devhood.com/messages/message_view-2.aspx?thread_id=72204
      > Thanks and Regards,
      > manish bafna
      > "SAL" wrote:

      sal | Wed, 04 Jun 2008 01:53:00 GMT |