If you are using Windows mode - you need to have a user  account set up on the
server.  Then add this account to the SQL database.

If you are using SQL server mode, then you only need a login and PW on the SQL
database. (best practice)

======================================
Stop spam on your domain, Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
======================================
Aspire to Inspire before you Retire or Expire!

  ----- Original Message -----
  From: J M
  To: CF-Talk
  Sent: Monday, February 09, 2004 7:30 AM
  Subject: CFMX + SQL Server in windows only security mode

  Hi all,
  Try as I might, I cannot get CF to connect to SQL Server in "Windows Only"
security mode with specially created accounts or even the sa account. I ask
because it is considered a security best-practice to enforce Windows-only
security in SQL Server, but obviously I need CF to work.

  If I switch to mixed-mode, it works fine. Am I missing something here? Can CF
only connect if mixed-mode security is enabled in SQL Server?

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

Reply via email to