Customers running a configuration of Microsoft Data Access Component (MDAC) 2.6 RTM, SQL Server 2000, and ODBC for SQL 3.6 may find that ColdFusion Advanced Security fails to authenticate. Here's a workaround:
ColdFusion: Authentication Failure Under a Configuration of MDAC 2.6 RTM, SQL Server 2000, and ODBC For SQL 3.6 (Allaire/Macromedia Knowledge Base Article, Updated March 9, 2001)