CFMX 7.0.1 COnnection to SQL 2000

[JFERO]

I am running MSDE and CFMX DE on my W2K laptop. I cannot connect to MSDE so
I am reluctant to upgrade our production server to CFMX unless I can resolve
this connection issue. when I follow th instructions in this technote
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652[/url] I get the
folowing error

:Connection verification failed for data source: CFERODEV
java.sql.SQLException: Error establishing socket.
The root cause was that: java.sql.SQLException: Error establishing socket.

I have used the laptops name and 127..0.0.1 in the server name.

Another time it indicated that there was an error that the URL.

When I try to connect using the MS SQL server I get the same error.

I 've reviewed some of the other posts and none of them seem to resolve this
issue for me. Any help would be appreciated

Thanks,

Eric O.

Any help would be appreciated

I am using the Laptops Name as the server name in the

[aUniqueScreenName]

I had the same problem with SQL Server 2000 and MX 7. It was resolved when SQL Server Service Pack 3a was installed.