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

From: Mandar Naik[MSFT] (mandarn_at_online.microsoft.com)
Date: 06/27/03 

Date: Fri, 27 Jun 2003 16:23:25 +0530

I'm a little confused about which one is Server1 and Server2 and which one
is the IIS and SQL Server.

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. 

--
Regards,
Mandar Naik
This posting is provided AS IS with no warranties, and confers no rights.
"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?

Relevant Pages

  • 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)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)
  • RE: My Documents Redirection error
    ... > is no need to manually migrate data from MSDE to SQL server and all dada is ... > How to back up and restore http://companyweb data in Windows Small Business ... Insert the Microsoft Windows Small Business Server 2003 Premium ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall SQL Server; ... Reinstall Monitoring and Sharepoint and make sure they work; ... On the Windows Configuration page, ...
    (microsoft.public.windows.server.sbs)