Re: Windows Authentication or SQL Server Authentication

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: Q: Named pipes and Windows (integrated) authentication
    ... >By the way, if you don't have SQL Enterprise Manager, there's an MSDE ... >>>his windows authentication to connect to the server. ... >>>Creating databases is only acomplished after you've already connected. ...
    (microsoft.public.sqlserver.connect)
  • RE: MELL and SQL
    ... At this point I'm logged in as admin and since ... have the necessary permissions for the installation. ... > Most third party apps don't use Windows Authentication, they use SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server Authentication
    ... I'm sorry to hear you are having some troubles with SQL authentication. ... can I would love to persuade you to use Windows authentication if at all ... > With VSTO using Visual Studio 2005, has anyone manage to use SQL Server ...
    (microsoft.public.vsnet.vstools.office)
  • Re: SQL Server uses Windows authentication
    ... > With Windows Authentication you do not put any credentials in the ... The connection uses the credentials of whatever ... >> 1 remote web server to connect to an SQL db on a completely different ...
    (microsoft.public.inetserver.asp.db)
  • Re: Login failed for ServerGuest
    ... SQL Server clients are authenticated as guests if Simple ... >| I have noticed that when I try to log in using Windows Authentication ... >|> You can enable the guest account but that's a security risk ...
    (microsoft.public.sqlserver.connect)