-
May 8th, 2012, 01:23 PM
#1
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
-
May 9th, 2012, 08:41 AM
#2
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.
-
May 9th, 2012, 09:48 AM
#3
Re: Authentication problem
Originally Posted by GremlinSA
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|