Windows Authentication or SQL Server Authentication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Word problems - 25 Oct 2006 19:47 GMT

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.

Reply to this Message

Arnie Rowland - 25 Oct 2006 20:16 GMT

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.

Signature

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

> Greetings,
>
[quoted text clipped - 8 lines]
>
> Thank you in advance for your assistance.

Reply to this Message

Word problems - 25 Oct 2006 20:35 GMT

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

> The "tightest security" will be Windows Authentication.
>
[quoted text clipped - 13 lines]
> >
> > Thank you in advance for your assistance.

Reply to this Message

Arnie Rowland - 25 Oct 2006 23:36 GMT

Look up how to use an Application Pool with IIS.

Signature

> Arnie,
>
[quoted text clipped - 25 lines]
>> >
>> > Thank you in advance for your assistance.

Reply to this Message