Re: IIS on server 2000

From: Ken Schaefer (kenREMOVE_at_THISadOpenStatic.com)
Date: 08/04/03 

Date: Mon, 4 Aug 2003 12:24:11 +1000

What type of authentication are you using? If you are using Integrated
Windows Authentication, then the webserver never has the user's password, so
it can't use that to login to SQL Server on the user's behalf.

You can use Basic authentication (plus SSL) instead.

Cheers
Ken

"zemote" <n@a.com> wrote in message
news:013701c3592a$dc032d00$a401280a@phx.gbl...
: This is the setup
:
: 1. Goto a web site (IIS) and you are prompted for a
: domain password.
:
: 2. Once logged in you can browse the site...until you go
: to a asp page that calls information from another server
: that has SQL Enterprise on it.
:
: 3. When you access a asp page from the website - it
: communicates with the SQL server which is setup with
: domain authentication - The SQL server requests a user id
: and password (doamin login and password) but since the
: asp page is running on the IIS webserver it sends the
: anonymous account information to the sql server not the
: login information from the user.
:
: 4.
: Does the ASP page need to aquire the user login
: information and send that to the sql server
:
: or
:
: Is there a setting in IIS to pass the user login
: information to the SQL server.
: thanks
:
:

Relevant Pages

  • Re: Cant Connect
    ... Then it's likely the authentication settings on the IIS side ... Try adding the IUSR account as a login in SQL Server ... > Cn.open CnStr ...
    (microsoft.public.sqlserver.connect)
  • Re:changing sa password / login
    ... authentication and it worked. ... >I think you might have made changes to SQL Server ... >Authentication" can not recognize SA login which is SQL ... >configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Security question ..
    ... > If you use NT authentication, a user's permissions to a database are ... Your assertion that a user's permissions are independent of the application ... Even using Access and "exploring" will require an ODBC login to SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re:changing sa password / login
    ... I think you might have made changes to SQL Server ... to make was using Mixed Authentication which will ... Authentication" can not recognize SA login which is SQL ... configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Kerberos / Authentication to SQL2K
    ... use Windows integrated security for database access. ... That SQL Server be running on the same computer as IIS. ... > authentication until I switched on impersonation either. ... > When set up on my web server however, I get the "Login failed for user ...
    (microsoft.public.dotnet.framework.aspnet)