Re: Cannot Generate SSPI Context - help

From: joker (no-spam_at_netzero.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 07:19:16 -0600

Just remember that the IUSR_<> account is a local account by default &
thus only has access to only the web server by default.

Manohar Kamath [MVP] wrote:

> Almost correct...
>
> The IUSR_<> account on the machine, should have Windows authentication
> rights on the remote SQL server. That way, you do not include the userid and
> password in the connection string. When a connection is "trusted," it means
> the user who is requesting the connection is a user on the SQL server as
> well.
>

Relevant Pages

  • Re: Memory Allocation - Win2k3 SP1 and SQL Server 2K SP4
    ... Microsoft SQL Server MVP ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Local logon for terminal server without specifying machine name?
    ... I want to set up a local account on a terminal server machine and allow this ... in the userid field. ... This time it worked and I was able to log into Terminal Services ...
    (microsoft.public.windows.terminal_services)
  • relay problem in sendmail-8.13.1 (FC3)
    ... I've got sendmail configured to reject relaying except for mail from a small ... server from another IP address, ... email destined for a valid local account is handled correctly ... Is there a configuration option that I must be missing? ...
    (comp.mail.sendmail)
  • relay problem in sendmail-8.13.1 (FC3)
    ... server from another IP address, ... email destined for a valid local account is handled correctly ... If an email arrives which is ... Is there a configuration option that I must be missing? ...
    (comp.mail.sendmail)
  • Re: Connect to AS from another workstation
    ... You can also work around this by setting up a local account on the AS2k ... server that has the *identical* username and password to a local account ... > system that allows you to "bypass" windows authentication. ... > Olap, though, you need to utilize windows authentication. ...
    (microsoft.public.sqlserver.olap)
Loading