DSN over VPN

[David Koehler]

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=17837.14401.15

[Mike Chabot]

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
<dkoehler@...> 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=17837.14401.15

[Misha Mishyn]

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 <mchabot@...> 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
> <dkoehler@...> 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=17837.14401.15

[David Koehler]

Good Grief, the SQL Server Authentication mode wasn't on. I set it to both Windows and SQL Server and the DSN works just fine. Thanks much Mike.  Also, I know using remote server will impact our application performance but the dataset is going to be relatively small and over a T1.

Thanks to you both.

Dave


 

>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
><dkoehler@...> wrote:
>>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4826
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15

[David Koehler]

Good Grief, the SQL Server Authentication mode wasn't on. I set it to both Windows and SQL Server and the DSN works just fine. Thanks much Mike.  Also, I know using remote server will impact our application performance but the dataset is going to be relatively small and over a T1.

Thanks to you both.

Dave


 

>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
><dkoehler@...> wrote:
>>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4827
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15