CF MX 7 and SQL Server 2005 data source issues... Its been awhile since I have written in here, but I want to share an issue I have just now resolved with SQL Server 2005 and Cold Fusion MX 7 regarding data source connections.

Problem:

I was having issues connecting from a Windows Server 2003 Ent. Edition box running CF MX 7 using the Cold Fusion Admin to a clustered SQL Server 2005 named instance.

Solution:

I changed my clustered instance of SQL Server 2005 to mixed mode authentication and used the following parameters:

CF Data Source Name: your_dsn_name
Database: db_name
Server: servername\instance_name
Username: {your_username}
Password: {your_password}

I referenced this article about changing to mixed mode authentication:

http://cfpayne.wopress.com/2006/07/21/changing-authentication-in-sql-server-2005-express/


Steps I took to resolve the issue:

1. Created a new login in SQL Server 2005 and mapped it to the correct default database.

2. Changed the Authentication Mode in SQL Server 2005 to Mixed Mode Authentication. (See link above.)
3. Tested connections using the general parameters listed above.

If anyone has comments or suggestions on their experiences using Windows Authentication in CF MX 7 please post as I would be interested in seeing others experiences in this arena.

-Carl (The Water Buffalo)  ¶ 10:03 AM