I have a remote server running Windows Server 2008 and SQL Server 2008. The local server is running Windows Server 2003 and SQL Server 2005. I have a permanent VPN tunnel between the two over a T1 line. I can ping each server from one another. I have the remote server as stand alone, ie; not part of the local domain.
Through CF Administrator (version 8) on the local server, I am trying to setup a DSN. If I try it using ODBC Driver (which, by the way, tests successfully in ODBC data source administrator), I get an error saying: Connection verification failed for data source: DATABASE java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][SQL Native Client][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][SQL Native Client][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON If I setup a DSN using the Microsoft SQL Server Driver, I get the error: Connection verification failed for data source: DATABASE java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'cf_user'. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'cf_user'. Cf_user is a valid login for SQL Server 2008. Thanks in advance for any suggestions. Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4823 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
