CF 7 and MS SQL 2005 Datasource Problems

[alexam]

Anyone having trouble connecting to a MS-SQL2005 dB from CF7? I'm running
these apps on a Windows XP machine.

I've installed the new JDBC driver from MM but still get the following error:

Connection verification failed for data source: CF_Other
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
socket to host and port: ORVAL:1433. Reason: Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver]Error establishing socket to host and port: ORVAL:1433. Reason:
Connection refused: connect

I've tried using "SQL Server" data type through CF Admin as well as "Other"
data type, specifying a JDBC URL of:

jdbc:macromedia:sqlserver://ORVAL:1433;databaseName=ColdFusion;
SelectMethod=direct;sendStringParametersAsUnicode= false;
MaxPooledStatements=0;AuthenticationMethod=Type2;

Driver Class: macromedia.jdbc.MacromediaDriver

Is this just a problem becasue MS-SQL2005 is still in beta?

Any help is appreciated. Thanks,

-Alexam

[tzimmerman]

I'm not sure that your problem has to do with the fact that the database is still in beta. One thing you might try is using the ip address in stead of ORVAL.

HTH

Ted Zimmerman

[IZEARTS]

I have the same trouble. But I am working with SQL Server 2000.
Any advices?

[BKBK]

Did you in the Coldfusion Administrator enter the correct username/password
combination for the database? e.g. username="sa"(database admin)

[sws]

Sorry if I'm a little late here...
Make sure the Windows' Firewall (or any firewalling software for that matter) is not blocking the connection.