Dave, Can you set up the exact same login on the local SQL 2005 server to see if that works? Is your password longer than 16 characters? Sometimes that is a problem. In your SQL Server 2008 I am assuming that you enabled TCP connections, specified a target port number, and turned on the SQL Server authentication mode in the security settings.
-Mike Chabot On Thu, Oct 1, 2009 at 1:13 PM, David Koehler <[email protected]> wrote: > > 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:4824 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
