IIS and SQL Server on different machines: how to connect with windows security

From: Paolo C. (noemail_at_ok.ok)
Date: 06/27/03

  • Next message: Jasper Smith: "Re: Log of Logins/Logouts" 
    Date: Fri, 27 Jun 2003 03:15:32 -0700

    Hi!
    I have a web server (Windows 2000 server) with IIS5
    and .NET Framework (SERVER1) and another server (Windows
    2000 Server) with SQL Server 2000 (SERVER2).
    I would like to connect to a db on SERVER2 from ASP and
    ASPX pages on SERVER1 using the Windows Authentication.
    I would like, to be precise, that IUSR_SERVER2 and ASPNET
    users of SERVER2 can connect to db on SERVER1.

    when I try to create the logins for this 2 users:

    exec sp_grantlogin 'Server2\IUSR_Server1'
    exec sp_grantlogin 'Server2\ASPNET'

    I get this error:

    Windows NT user or group 'Server2\IUSR_Server1' not found.
    Check the name again.
    Windows NT user or group 'Server2\ASPNET' not found. Check
    the name again.

    Anyone can help me?

  • Next message: Jasper Smith: "Re: Log of Logins/Logouts"

    Relevant Pages

    • SecurityFocus Microsoft Newsletter #154
      ... MICROSOFT VULNERABILITY SUMMARY ... ISS RealSecure Server Sensor SSL Denial Of Service Vulnerabi... ... Roger Wilco Remote Server Side Buffer Overrun Vulnerability ... available for Microsoft Windows operating systems. ...
      (Focus-Microsoft)
    • SecurityFocus Microsoft Newsletter #49
      ... Subject: SecurityFocus Microsoft Newsletter #49 ... Microsoft Windows NNTP Denial of Service Vulnerability ... Microsoft IIS SSI Buffer Overrun Privelege Elevation Vulnerability ... Microsoft ISA Server H.323 Memory Leak Denial of Service... ...
      (Focus-Microsoft)
    • Re: SQL Server 2005 Login Problem
      ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... 2- Mixed Authentication (through SQL Server logins and Windows accounts) ...
      (microsoft.public.sqlserver.clients)
    • RE: My Documents Redirection error
      ... We can upgrade the instance SharePoint ... >> is no need to manually migrate data from MSDE to SQL server and all dada ... >> How to back up and restore http://companyweb data in Windows Small ...
      (microsoft.public.windows.server.sbs)
    • Questions Relating to Administering Windows 2000 Server
      ... installed the network client on the target computer. ... Sarah has been attempting to install Windows 2000 ... Server for two days. ... Sarah has checked the cables and hard drives. ...
      (microsoft.public.cert.exam.mcse)