Re: Intranet connect to SQLServer Under user's account.

From: Fred (fred.boistuaud@dorsetsoftware.com)
Date: 01/16/03 

From: "Fred" <fred.boistuaud@dorsetsoftware.com>
Date: Thu, 16 Jan 2003 09:46:08 -0000

This did not work.

But thanks anyway.

Fred.

"Erik Porter [.NET MVP]" <erikporter@mvps.org> wrote in message
news:#cejR3KvCHA.616@TK2MSFTNGP11...
> Not sure if this is the fix that will do it, but trying changing the
> authorization to this...
>
> <authorization>
> <deny users="?" />
> <allow users="*" />
> </authorization>
>
> Also, I believe you'll have to setup a group in SQL Server to accept
> everyone from your domain.
>
> Erik Porter
> Microsoft .NET MVP
>
> "Fred" <fred.boistuaud@dorsetsoftware.com> wrote in message
> news:uadzjjIvCHA.2476@TK2MSFTNGP10...
> > Hi there,
> >
> > I'm trying to set up an intranet where people login under their own
> windows
> > account.
> >
> > I have set up the Web site so that it uses Windows Integrated security,
> i.e
> > on the 'authentication methods' screen under ISS, 'Integrated Windows
> > authentication' is the only selected option.
> >
> > I also have the following settings in my web.config file:
> > <authentication mode="Windows" />
> > <identity impersonate="true" />
> > <customErrors mode="Off" />
> > <authorization>
> > <allow users="*" />
> > </authorization>
> >
> > To connect to SQLServer I use a connection string as follow:
> > 'server=DSDEV1\SQL2000; database=Intranet; Trusted_Connection=yes'.
> >
> > On a test webpage I can output the user account being used:
> > User.Identity.IsAuthenticated returns true,
> > User.Identity.AuthenticationType returns 'Negotiate'
> > and User.Identity.Name returns my 'MyDomainName\MyUserName'
> >
> > From visual Interdev I can run the app in debug or release mode, and
> > everything is OK.
> >
> > Now I want other people to connect to ISS on my machine, and connect to
> > SQLServer using their account.
> > The 'User' object does return the information I expect, but I keep on
> > getting an error like: 'Login failed for user 'NT AUTHORITY\ANONYMOUS
> > LOGON'.', when trying to connect to SQLServer.
> >
> > Can anyone tell what's wrong?
> >
> > Thanks
> >
> > Fred
> >
> >
> >
> >
> >
> >
>
>

Relevant Pages

  • Re: Windows Passwords
    ... "Windows Vista for Dummies" manual. ... I started by creating a test user account. ... The reason I say this is that, when I turned the Guest ...
    (microsoft.public.windows.vista.general)
  • Re: Help Me Understand User Accounts
    ... When you log off and log back in as the limited user you'll be able to ... you'll need to set up a new email account (under the new ... limited user account) the same as you had before, ... Administrator accounts are the default type of account ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Windows Service Account
    ... you can use the find IIDentity to the user to give folder permissions ... The OP does not need to find which user account is running the Windows ... Local System account has mighty ...
    (microsoft.public.dotnet.general)
  • Re: DC Temporarily Off-line, Remaining DC Struggling
    ... suspects this issue is related to the account and roaming profile. ... Please make sure all user accounts are replicated to win2k3 DC. ... Does this issue only occurs if the user account uses ...
    (microsoft.public.windows.server.active_directory)
  • Re: Logoff / Slow Bootups / Outlook attachements / Outlook Not res
    ... When you logon the problematic user account on the good user's computer, ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)