Re: ASP/SQL Server Setup

From: Matt MacDonald (mattsmac_at_hotmail.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 10:10:09 -0400

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: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
Loading