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

From: BJ Freeman (bfree_at_free-man.com)
Date: 06/27/03

  • Next message: nfr: "How do I change a user name" 
    Date: Fri, 27 Jun 2003 07:36:25 -0700

    I am guess you don't have trustedrights between the two servers.
    another approach is to use TCP/IP(assuming your using TCPIP Network) and
    have the login on the SQL server. So NT loging would not be used.
    "Paolo C." <noemail@ok.ok> wrote in message
    news:035201c33c95$0a9f46b0$a001280a@phx.gbl...
    > 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: nfr: "How do I change a user name"

    Relevant Pages

    • Re: ADMIN Account Issue
      ... Can you actually login to one of the DCs at its console? ... the Default Domain Controllers Policy under Windows Settings->Security ... > Terminal Services in Administrative mode NOT Application mode. ... > when trying to RDP to any of the DC servers I get a message that says: ...
      (microsoft.public.win2000.active_directory)
    • xp_logininfo returns error for NT logins on trusted domain
      ... I am setting up SQLServer replication between servers on ... The publishing servers are a mixture of NT and Windows 2000 ... The subscribibg server is Windows 2000. ... If I add a SQLServer account which is any login on the ...
      (microsoft.public.sqlserver.replication)
    • Re: Linux authentication via AD
      ... Primarily I need to integrate Linux ... servers, but I do have a few OpenBSD servers. ... > a way to do this under older AIX) allows people to login authenticating ... > text passwords authenticate to the Windows Password Server as well. ...
      (comp.os.linux.security)
    • Re: Update site?
      ... The reason I needed to login from the same machine is - ... > Users by default are NOT allowed to logon to servers. ... You can change this in the Domain Security Policy I ... there open Domain Controller security policy. ...
      (microsoft.public.exchange.admin)
    • RE: Linked Server
      ... I’ve got two servers, say ServerA and ServerB, that are Windows 2000 Adv'd ... their Windows login mapped into a Domain level group, ... This works except for one thing: I cannot get the linked servers to work. ...
      (microsoft.public.sqlserver.security)