Windows Authentication Setup - Support Queries - myLittleTools Community Forum

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » Windows Authentication Setup

Windows Authentication Setup

Options · View

Previous Topic · Next Topic

danwturner

Posted: Sunday, December 18, 2011 5:20:17 PM

Rank: Newbie
Groups: Member

Joined: 12/18/2011
Posts: 2
Points: 6
Location: Fort Worth, TX, USA

I am running....
IIS7 with website authentication set to Windows authentication.
SQL 2005 SP4 running in mixed authentication mode (on a seperate server)

I can log in fine using SQL authentication but how can I configure Windows authentication? When I select it from the login screen, it fails with the error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." Is there any way to pass the logged in user's (the person browsing the myLittleTools site) credentials to SQL? Does it always use the identity that IIS is running under instead?

Thanks for the help,

Dan

elian

Posted: Friday, December 30, 2011 8:35:13 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

I hope this link can help you
http://stackoverflow.com/questions/2101077/asp-net-web-application-trying-to-use-impersonation-and-delegation-to-connect-to

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » Windows Authentication Setup

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.