Re: BTW

From: Ryan LaNeve (ryanno@spamlaneve.com)
Date: 07/21/02


From: "Ryan LaNeve" <ryanno@spamlaneve.com>
Date: Sun, 21 Jul 2002 02:53:26 -0400


"Richard Lawson" <nospam@nospam.com> wrote in message
news:#ZvCtrHMCHA.1112@tkmsftngp10...
> I already read in a previous post that NT is more secure than SQL security.
> That surprises me. So, is NT meant of Internet/Extranet and SQL is for
> Intranet?
>
> Rich

You need to be more specific about your environment to determine the best course
of action. If you're building a website, what kind? Intranet? Extranet/Internet?
If the latter, are the users authenticating against IIS with valid NT accounts,
or are you storing their personal user/pass values in the db itself and using
anonymous authentication in IIS?

All of these things matter in determining how to structure your data-access
methods, though in all scenarios there is a way to use NT Authentication. Here's
a link to get you started (assumes SQL 2K):
http://www.microsoft.com/sql/techinfo/administration/2000/securityWP.asp

Good luck,
Ryan LaNeve



Relevant Pages

  • RE: Confusion on standard security methodologies.
    ... Application will talk to a back-end SQL ... By "back-end," I assume you mean on a different box from IIS? ... If SQL is on a separate box, you won't be able to use NT authentication ... impersonations (meaning that once passed to the IIS server, ...
    (microsoft.public.inetserver.iis.security)
  • Re: Cached Logon
    ... It appears that the IIS and the SQL are installed on one machine? ... the scenes" windows authentication information? ... The folder on IIS holds all 3 .asp files. ... On the server I was logged in as domain1\administrator. ...
    (microsoft.public.windows.server.general)
  • Re: Cached Logon
    ... It appears that the IIS and the SQL are installed on one machine? ... the scenes" windows authentication information? ... The folder on IIS holds all 3 .asp files. ... On the server I was logged in as domain1\administrator. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cached Logon
    ... It appears that the IIS and the SQL are installed on one machine? ... the scenes" windows authentication information? ... The folder on IIS holds all 3 .asp files. ... On the server I was logged in as domain1\administrator. ...
    (microsoft.public.sqlserver.server)
  • Re: Cached Logon
    ... It appears that the IIS and the SQL are installed on one machine? ... the scenes" windows authentication information? ... The folder on IIS holds all 3 .asp files. ... On the server I was logged in as domain1\administrator. ...
    (microsoft.public.win2000.networking)

Quantcast