Re: Windows Authentication or SQL Server Authentication

Look up how to use an Application Pool with IIS.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Word problems" <Wordproblems@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C9C58B26-9941-4490-87A7-5542E9A3CE9A@xxxxxxxxxxxxxxxx
Arnie,

Thank you for your response. I forgot to mention that this module will be
access from the Internet. So going with the Windows Authentication
solution
would I create a generic account in AD for the webportal then assign it to
the SQL DB?

Thanks

"Arnie Rowland" wrote:

The "tightest security" will be Windows Authentication.

But that may require all of your users to have a login in Active
Directory.
If that is the situation, then go for Windows Authentication.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to
the
top yourself.
- H. Norman Schwarzkopf


"Word problems" <Wordproblems@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9B4DB97F-FAA6-4E2D-A445-654DFE1F48D8@xxxxxxxxxxxxxxxx
Greetings,

I have a new software package that is running on SQL 2005 Standard. I
am
attempting to install a webportal module to the software.

When granting the webportal module access to the SQL DB should I use
Windows
Authentication or SQL Server Authentication? I am interested in the
solution
that will provide the tightest security.

Thank you in advance for your assistance.






.

Relevant Pages

  • Re: Modifying Data Directly through Studio Manager
    ... Enterprise manager (in SQL 2000) never had a problem ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... 'tool' to allow your customers to manage their data. ...
    (microsoft.public.sqlserver.tools)
  • Re: NIC settings for SQL 2005 and windows 2003?
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... It would seem so, but this fellow Microsoft MVP in SQL, say's that isn't ... always use the ""Maximize date throughput for file sharing" setting. ...
    (microsoft.public.sqlserver.connect)
  • Re: Schema Problems
    ... So there's no secure way to allow creation of objects but not deletion of ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... in SQL Server 2005 we have a new feature as DDL Triggers. ...
    (microsoft.public.sqlserver.security)
  • Re: English Query
    ... English Query has been discontinued for SQL 2005, ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.olap)
  • Re: Domain or Workgroup
    ... Windows authentication provides better security, better password control, ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... or to remain in their work group and access SQL Server through Server ...
    (microsoft.public.sqlserver.clients)