Connecting to SQLServer 2k named Instance
Hey guys, this time i need some URGENT help, i swapped from windows to linux platform and using CF9, when i create a DSN in windows using SERVER_NAME\INSTANCE_NAME for the Server field, filling user name and password with a Microsoft SQL Server native DSN works perfectly, but when i do this same thing on Linux i get this nasty error:
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.
The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.
So i tryed to create a connection using the "Other" as DSN type and filled out this info:
CF Data Source Name: Test
JDBC URL: jdbc:sqlserver://SERVER_NAME\INSTANCE_NAME:1433;DatabaseName=MyDatabase
Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver Name: SQL Server JDBC
User name: myuser
Password: mypass
i get this error:
Connection verification failed for data source: test
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host FULLSQL, port 1433 has failed. Error: "Connection refused. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
This was done after downloading sqljdbc_3.0.1301.101_enu.tar.gz from microsoft's web site and placing the sqljdbc4.jar file inside the /opt/coldfusion9/runtime/lib directory.
So basically the first way to create the connection works on windows but not on linux, and the second way does not work in any place even tho it's supposed to be working...
Please send me some help ASAP, need this thing working BADLY!
