Intranet connect to SQLServer Under user's account.

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

From: "Fred" <fred.boistuaud@dorsetsoftware.com>
Date: Wed, 15 Jan 2003 11:26:18 -0000

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: prompt for admin name and password
    ... administrator it prompts me for a user name and a password. ... with a non-privileged domain account and need to elevate to an ... I know a lot free windows password recovery ways. ... The first thing which you check if you forget login password. ...
    (microsoft.public.windows.vista.administration_accounts_passwords)
  • Re: Client tools access to SS remote nstance - 2 diff. Win Server domain accounts ?
    ... Well, when I need to run at higher rights, I right click on the SSMS icon and choose Run As ... That gives me a dialog to enter my administrator account and password. ... login with my normal domain user account. ... SS that I use to login in that RDP session (Windows login) to then ...
    (microsoft.public.sqlserver.setup)
  • Re: Two option start-up for Wndows XP Home?
    ... Windows XP Home. ... Why don't you simply create another Windows account? ... account when you login, all your startup items will load. ...
    (microsoft.public.windowsxp.general)
  • How do I Recover / Reset / Remove / Crack / Hack Lost Windows Password?
    ... So if you have forget your user account password then try this: ... In Safe Mode Windows will show this in-built Administrator account in Login screen. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Windows equiv of UNIX "Restricted Users"??
    ... the Network and Users still in the local login rights on numerous ... defining a domain account does grant broad access. ... the "Everyone" permissions in Windows, will be limited to have access ONLY ...
    (microsoft.public.windows.server.security)