You also can linked another DB server through your local SQL server and do all SQL via linked server. http://msdn.microsoft.com/en-us/library/ms188279.aspx
And keep in mind that using remote server (SQL in your case) will impact on your application performance especially if you are going to work with a big dataset. Regards, Misha On Thu, Oct 1, 2009 at 2:05 PM, Mike Chabot <[email protected]> wrote: > > 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:4825 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
