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

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

Date: Fri, 27 Jun 2003 05:41:33 -0700

>-----Original Message-----
>I'm a little confused about which one is Server1 and
Server2 and which one
>is the IIS and SQL Server.
>
Hi, you are right, I reformulate the question:

I have a web server (Windows 2000 server) with IIS5
and .NET Framework (SERVER2) and another server (Windows
2000 Server) with SQL Server 2000 (SERVER1).
I would like to connect to a db on SERVER1 from ASP and
ASPX pages on SERVER2 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_Server2'
exec sp_grantlogin 'Server2\ASPNET'

I get this error:

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

>>>
However, if your question is about adding a local user of
another server
into your SQL Server running on a different machine , this
cannot be done.
If both the servers are in the same domain, you can give
access to Domain
accounts within your SQL Server.
>>>

You are right, I was also thinking of this.
So, what do you think is the best way to connect from ASP
using windows authentication from a remote machine?
And why do we need IUSR and ASPNET account on the local
machine, if we can only use them on a IIS on the local,
but not on a different server? I thought connecting to db
with theese users from asp and aspx page is the
reccomended practice...
Thanks in advance

Relevant Pages

  • Re: IIS Start up errors
    ... provide the detailed steps to reinstall the IIS server in SBS 2003 server. ... For example, programs such as Microsoft ... In the Currently installed programs list, click Windows Small Business ...
    (microsoft.public.windows.server.sbs)
  • Re: Active Directory Services cannot find the web server
    ... I am having the same problem with a windows xp pro with iis 5.1 ... incedently does not work properly when connecting to the server. ... both the client and server and still no luck. ...
    (microsoft.public.dotnet.faqs)
  • Re: restated: VS Develper (non Admin) missing IIS MMC Management
    ... > debug ASP in VB.Net, and of course manage IIS MMC. ... > Microsoft Development Environment ... > Information Server on the client and the server. ... > server from a Windows NT 4.0 client. ...
    (microsoft.public.dotnet.framework.setup)
  • Re: restated: VS Develper (non Admin) missing IIS MMC Management
    ... > debug ASP in VB.Net, and of course manage IIS MMC. ... > Microsoft Development Environment ... > Information Server on the client and the server. ... > server from a Windows NT 4.0 client. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: restated: VS Develper (non Admin) missing IIS MMC Management
    ... > debug ASP in VB.Net, and of course manage IIS MMC. ... > Microsoft Development Environment ... > Information Server on the client and the server. ... > server from a Windows NT 4.0 client. ...
    (microsoft.public.dotnet.general)