Re: Windows Authentication with IIS on separate machines

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


From: "Ricardo Palmeira" <palmeira@tce.pe.gov.br>
Date: Thu, 21 Nov 2002 03:14:29 -0800


Thanks Tomislav for your help.

Yes, setting Basic Authentication in IIS works, but the
users must give their logins and passwords again.

Using Integrated Windows Authentication didn't work for
you?

Thanks,

>-----Original Message-----
>
>"Ricardo Palmeira" <palmeira@tce.pe.gov.br> wrote in
message
>news:b5be01c290a1$6a90bcc0$8df82ecf@TK2MSFTNGXA02...
>> 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'.
>
>Using IIS snap-in set the directory security to basic
authentication
>(anonimus and windows methods should not be selected).
>
>Tomislav Kralj
>tomislav.kralj1@zg.tel.hr
>
>
>.
>



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: Windows Authentication question
    ... logins for our applications, because we are using NetWare for users. ... Windows authentication is more secure. ... then connect to SQL Server on your behalf. ... If your application is a two-tier app, ...
    (microsoft.public.sqlserver.security)
  • Windows authentication from ASP.net application to Sql Server
    ... windows authentication. ... And I trun annonymous login. ... I am wondering what is the correct setup for the IIS and Sql Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: what happend if deny login to "sa"??
    ... "Sue Hoegemeier" escribió en el mensaje ... And SQL Server does not allow you to use sp_droplogin to drop sa. ... If you want to prevent logins with sa, use Windows authentication only. ...
    (microsoft.public.sqlserver.connect)
  • Re: Need Help w/ SQLServer Express Authentication
    ... Windows Authentication can not be disabled using Mixed Authentication. ... You can only disable SQL Server authentication and Microsoft recommends using Windows Authentication when possible. ... Logins make your users to connect and perform their tasks in SQL Server. ...
    (microsoft.public.sqlserver.setup)