Re: CF and MS SQL server authentication

[Tom Kitta]

I want Windows Authentication for security reasons, SQL server simply is not as secure as Windows. SQL server 2000 does not support locking out, minimal password length, password expiry etc. So someone can setup a system whereas the SQL server is being bombarded with attempts to gain access, windows will lock the user out. SQL server admin guide recommends using windows authentication and fall back to SQL authentication in special circumstances (also for someone out there using win98 or winME which do not support windows authentication).

As for running SQL server on private network, that would be fine except for remote administration - how can one with ease connect to a host on a private network from a remote location.

TK
  ----- Original Message -----
  From: Tangorre, Michael
  To: CF-Talk
  Sent: Tuesday, December 09, 2003 1:38 PM
  Subject: RE: CF and MS SQL server authentication

  Tom,

  Just out of curiosity, why do you prefer Windows authentication? I always
  thought SQL Server authentication was better...
  I am definitely Interested in responses...

  Mike

  -----Original Message-----
  From: Tom Kitta [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, December 09, 2003 1:37 PM
  To: CF-Talk
  Subject: CF and MS SQL server authentication

  When setting up ColdFusion to work with MS SQL server 2000 I am having
  trouble with usage of Windows only authentication (prefered), I am forced to
  use SQL authentication. SQL and CF run on different computers on the same
  network. What accounts (permissions) should SQL and CF work on for windows
  authentication to work?

  TK
    _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---