Active Directory and SQL Server Connection

We have 2 servers running Windows 2003. One is the IIS server the other is a
SQL server. We made a web page that gets the using users name through their
logon from active directory. We then query the SQl server looking for
information about the user. Our problem, when we have anonymous access turned
off and integration turned on, we get a login failed, not trusted connection.
If we add an anonymous user from the domain that has access to the SQL
server, we get data, but of the anonymous user, not the using client. It
appears once we post to the server, the anonymous access takes over and
everything is geared to that user ID.

How do we do both?

Thanks


.

Relevant Pages

  • Re: Accessing a web application anonymously
    ... If you need to configure anonymous access, first make sure that IUSR account ... has read permissions (NTFS permissions) on the content? ... If your IIS server is member of domain then you will need the following ...
    (microsoft.public.inetserver.iis.security)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
Loading