Hi all,
I'm attempting to configure a development environment with IIS, CFMX8 and SQL
Server 2005 developer edition, all running on top of XP SP2. The process just
to get to this point has been painful enough, but now I've hit a bug that I
cannot seem to get around. I was hoping somebody else may have already run
into this.
When I attempt to connect to SQL Server via the CF administrator, I get the
following error message:
Connection verification failed for data source: trumpDBtest
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot
open database {my database} requested by the login. The login failed.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][SQLServer]Cannot open database {my database} requested by the login.
The login failed.
I'm not much of a DBA, and it's the first time I've ever worked with SQL Server
2005, but here's what I've managed to work through:
1. I figured out that SQL Server 2005 needs to be running in "Mixed Mode
Authentication" instead of "Windows Authentication Mode".
2. By default, SQL Server 2005 disabled connections to it via Named Pipes and
TCP/IP. I enabled both (though, I think I only really needed to enable TCP/IP).
3. I attempted to use a MS JDBC driver instead of the CF JDBC driver, but
ended up with pretty much the same error message. I followed directions at the
following URL, modifying from 2005 Express to 2005 where necessary:
http://www.fusioncube.net/?p=59
4. I downloaded the latest version of Java (1.4.2_15), and pointed CFMX8 to it
instead of the JVM that comes with CFMX8.
5. I set up a login account in SQL Server 2005 that I then invoke from the cf
administrator (I called it "cfuser"). I set the default database on that SQL
user to be the DB I wanted, and I unchecked "enforce password policy".
It certainly appears I'm actually getting to SQL Server 2005 from Cold Fusion,
and that the failure is happening once I've made the initial connection. I
read someplace that somebody with a similar problem was forced to set up an
ODBC connection, but a) I don't really know how to do that, and b) it certainly
seems like I should just be able to use the built-in JDBC drivers, dammit. (-;
Any guidance is greatly appreciated.
Thanks,
Ben
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289217
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
