CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Posts
    47

    Exclamation Authentication problem

    Hi,

    I've always developed using connectionstrings with sql authentication but this time i need to do it with windows authentication

    i have an IIS server in one city, and many sql servers in different cities
    i can connect to any sql server using windows authentication in sql management studio
    i can even connect to any sql server in visual studio (http://localhost:49161/InicioSesion.aspx)
    but if i try to do it here: http://localhost/InicioSesion.aspx i get the "Error de inicio de sesión del usuario 'NT AUTHORITY\ANONYMOUS LOGON'."

    if i change the ApplicationPoolIdentity to my windows account in the anonymous logon option (IIS) it works but i don't want everybody to be using my account instead of theirs

    what should i do?
    thanks in advance

  2. #2
    Join Date
    Jun 2005
    Location
    JHB South Africa
    Posts
    3,772

    Re: Authentication problem

    windows authentication uses the Authentication of the System requesting the SQL connection.. IE. the IIS server.. You could try setting up IIS to authenticate the every user (Do not allow Anon logins)...
    Articles VB6 : Break the 2G limit - Animation 1, 2 VB.NET : 2005/8 : Moving Images , Animation 1 , 2 , 3 , User Controls
    WPF Articles : 3D Animation 1 , 2 , 3
    Code snips: VB6 Hex Edit, IP Chat, Copy Prot., Crop, Zoom : .NET IP Chat (V4), Adv. ContextMenus, click Hotspot, Scroll Controls
    Find me in ASP.NET., VB6., VB.NET , Writing Articles, My Genealogy, Forum
    All VS.NET: posts refer to VS.NET 2008 (Pro) unless otherwise stated.

  3. #3
    Join Date
    Aug 2007
    Posts
    47

    Re: Authentication problem

    Quote Originally Posted by GremlinSA View Post
    windows authentication uses the Authentication of the System requesting the SQL connection.. IE. the IIS server.. You could try setting up IIS to authenticate the every user (Do not allow Anon logins)...
    I disabled anonymous authentication and it doesn't work either
    i've read about identity impersonate but no success so far

    the only thing that works is removing ApplicationPoolIdentity and adding my windows account instead

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured