Im battling to setup a Datasource to MSSQL 2000 personaledition

[cfdevshed]

HI All,

Im settting up a local server at home... The server is Win2k Server.. Ive
installed CFML 7,0,0,91690.. And now im battling to setup a datasource to it..

This is the error I get when trying to setup the datasource

Connection verification failed for data source: CFIntranet
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error
opening/loading macromedia.jdbc.sqlserver.sqlserver.properties. If a Security
Manager is employed, check to see that proper permissions have been granted.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver]Error opening/loading macromedia.jdbc.sqlserver.sqlserver.properties. If
a Security Manager is employed, check to see that proper permissions have been
granted.

[ksmith]

Recommendations:
[num]Uninstall CFMX 7.00
Install trial or developer from [url]www.adobe.com/downloads[/url] which will be CFMX 7.02
Install latest JDBC drivers from technoted listed near top of
[url]www.adobe.com/support/coldfusion[/url]
In windows administrator create a test ODBC dsn, and in the client config area
confirm it is using TCPIP only
If it fails, turn on TCPIP in MSSQL server
Retest
[/num]