Cannot create SQL Server 2005 DSN in CF Administrator

See if this helps:

http://carehart.org/blog/client/index.cfm/2006/7/8/sql2k5_Error_establishing_socket

--
Ken Ford
Adobe Community Expert - Dreamweaver
Fordwebs, LLC
http://www.fordwebs.com


"ssailer" <webforumsuser@macromedia.com> wrote in message news:fvd175$p3d$1@forums.macromedia.com...
>I have just started using SQL Server 2005 on a laptop running Windows Vista.
> When I try to create a new DSN in CF administrator, I keep getting the
> following error message:
>
> Connection verification failed for data source: sps
> java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
> socket to host and port
> The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
> Driver]Error establishing socket to host and port
>
> I have no problem creating the database or adding tables to the database, but
> I just cannot create the DSN. Has anyone run into this before and how can I
> fix it???? I've never seen this message before in SQL Server 2000, which is
> running just fine on my PC with Windows XP.
>
> HELP!!!
>