Member Avatar for sureshrajanmca

in trusted connection hw will we get the client windows user id.i am getting only server windows user id when i run the application in server.by when client run iam not getting client windows user id.

  • 3 Contributors
  • 10 Replies
  • 149 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by jinus
Member Avatar for dnanetwork

give me some more info..
i dnt understand your case..!

Member Avatar for sureshrajanmca

give me some more info..
i dnt understand your case..!

In client system when I run the URL, I got this below error"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'".

I used TrustConnection=yes in connection string.

Member Avatar for sureshrajanmca

In trusted connection. The below error Ocuur
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.


the Original Application is in my sys, when i run this ,its work fine.


when some one acces this application using my SystemIP the above error occurs.

Edited by sureshrajanmca because: n/a
Member Avatar for dnanetwork

i'm not sure about this but
wot type of operation you trying..
Insert or Select..

Member Avatar for sureshrajanmca

I write the Connectionstring and open the connection, when i run this application in client system the above error occurs.

Member Avatar for dnanetwork

again i'm not sure..
you need to provide access rights to database.

show me your connection string..

Edited by dnanetwork because: n/a
Member Avatar for sureshrajanmca

Already gave access rights to database.

IN web.config

<add name="MyDbConn1" connectionString="Server=172.16.0.99\mssql;Database=ss;Trusted_Connection=Yes;" />
Dim wic As WindowsImpersonationContext = Nothing
        wic = WindowsIdentity.Impersonate(IntPtr.Zero)
     Dim cnn As New SqlConnection(ConfigurationManager.ConnectionStrings("MyDbConn1").ToString())        

      cnn.Open()                             //in this line client system got error
        If cnn.State.ToString() = "Open" Then
            Response.Write("connected")
        End If
Edited by Ezzaral because: Added code tags. Please use them to format any code that you post.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.