Re: ASP/SQL Server Setup

From: Eliyahu Goldin (removemeegoldin_at_monarchmed.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 17:42:24 +0200

Matt,

Yes you can. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch07.asp

Eliyahu

"Matt MacDonald" <mattsmac@hotmail.com> wrote in message
news:O1IuokJTEHA.3968@TK2MSFTNGP09.phx.gbl...
> The thing is, I don't want to have to put a user in my database for every
> person who is going to login to the site. Can't I have ASP.NET log intot
> SQL server using the windows authentication for the machine that IIS is
> running on? It works fine if IIS and SQL Server are on the same machine,
> just not when they are on different ones.
>
>
> "Cowboy (Gregory A. Beamer) [MVP]" <NoSpamMgbworld@comcast.netNoSpamM>
wrote
> in message news:O4uXYIJTEHA.1172@TK2MSFTNGP11.phx.gbl...
> > You will have to turn off anonymous access for the website and force the
> > user to log in. If you have a login page already, you can work with
Active
> > Directory to link the user to his account, but having the Windows login
> box
> > automagically pop up is a lot easier. As long as the user is in the DB,
> you
> > should be fine now.
> >
> > Reason: User logged in as IUSR_ComputerName when they hit an anon
website.
> >
> > --
> > Gregory A. Beamer
> > MVP; MCP: +I, SE, SD, DBA
> >
> > ************************************************
> > Think Outside the Box!
> > ************************************************
> > "Matt MacDonald" <mattsmac@hotmail.com> wrote in message
> > news:eRStn%23ITEHA.3756@TK2MSFTNGP11.phx.gbl...
> > > Hi all,
> > > I'm trying to set up a web server using IIS on a different machine
> than
> > my
> > > SQL Server is on. I have my web site set up to use windows
> > authentication,
> > > and I have ASPNET set up as a user on the database. I still get the
> > "Login
> > > failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server
> > > connection." though. Anyone have any ideas how to fix this?
> > >
> > > Thanks,
> > >
> > > Matt
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Cannot connect to database
    ... when you use iis, its uses the aspnet account which is local and is probably not set up to access your sqlserver. ... I open Visual Web Developer 2008 express on desktop and Select File>open Website, and browse to a folder on DevBox. ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.dotnet.framework.aspnet)
  • IIS vs ASP.Net Authentication problem
    ... Requirement is to use 'domain\iisuser' to authenticate in SQL Server ... Only Integrated Windows Authentication enabled (Anonymous/basic/digest ... unchecked) in IIS 5 ... Login failed for user 'CCMIWS05\ASPNET'. ...
    (microsoft.public.dotnet.security)
  • Re: Firewall Affecting Website Page Load Speed?
    ... all of the others have one or two images on the page. ... I am hosting this website at home on a machine running Windows XP Pro ... You're using IIS on Windows XP. ... You have SQL Server running on the same box. ...
    (comp.security.firewalls)
  • RE: Audit Table
    ... login to SQL Server after that user has logged into IIS using Basic ... it seems impossible to monitor the ...
    (microsoft.public.sqlserver.security)
  • kerberos the story so far
    ... I am trying to connect to a SQL server throu IIS using impersonation. ... monitoring the IIS connection with the default login, ... If you force a kerberos windows login the IIS seems to use kerberos ...
    (microsoft.public.win2000.active_directory)