Windows Authentication with IIS on separate machines

From: Ricardo Palmeira (palmeira@tce.pe.gov.br)
Date: 11/20/02 

From: "Ricardo Palmeira" <palmeira@tce.pe.gov.br>
Date: Wed, 20 Nov 2002 06:30:47 -0800

Hi,

We're trying to make our Intranet pages use Sql Server
Windows Authentication. We're using Windows 2000, with SQL
Server on one machine and the IIS on another.

That only works when the user logs on the IIS Server,
otherwise we're receiving the error:
Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

When SQL and IIS are on the same machine everything ok.

Thanks in advance.

Relevant Pages

  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: New to Merge/Replication
    ... ADO.NET 3.0 includes "Synchronization Services" that does not require IIS. ... Hitchhiker's Guide to Visual Studio and SQL Server ... It was my deepest hope that Merge/Replication between SQL Compact Edition and SQL Server 2005 Enterprise Edition would have it's own sync services NOT dependent on IIS. ... You can use merge replication with SQL Server on your main desktop serving as the publisher with SQL Compact on PPC, TabletPC, or other desktops as subscribers, so that would probably be the easiest solution for you. ...
    (microsoft.public.sqlserver.ce)
  • Q: Windows Authentication
    ... Is Windows Authentication possible without a domain controller? ... Microsoft SQL Server Login ... SQLState: '01000' ... SQL Server Error: 6 ...
    (microsoft.public.sqlserver.connect)
  • Re: Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... users must give their logins and passwords again. ... >> We're trying to make our Intranet pages use Sql Server ... >> Windows Authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Help on synch to SQL server
    ... from SQL CE to SQL Server from your smart-device application's code. ... This can occur whenever the device has a network path to IIS, ... Unlike merge replication between SQL Servers where you can use RMO ... Ideally I would like to use Sql CE to synch with a SQL ...
    (microsoft.public.sqlserver.ce)