TOTALLY TROUBLED With SQL Server 2005

hi

i'm installed sql server 2005, i'm using coldfusion mx 7.0.2 hotfixes, , i'm still without datasource connected mssql2k5

i used traditional way create datasource using embeded driver of microsoft sql server put correct data on fields , message of error this:

connection verification failed data source: recofoce21
java.sql.sqlexception: [macromedia][sqlserver jdbc driver]error establishing socket. connection refused: connect
the root cause that: java.sql.sqlexception: [macromedia][sqlserver jdbc driver]error establishing socket. connection refused: connect

then read microsoft released jdbc driver, installed onto de coldfusion has mentioned in tech note:

enabled http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=ded4216b

i create new datasource example showed , nothing:

connection verification failed data source: redcofoce
com.microsoft.sqlserver.jdbc.sqlserverexception: la conexión tcp/ip al host ha fallado. java.net.connectexception: connection refused: connect
the root cause that: com.microsoft.sqlserver.jdbc.sqlserverexception: la conexión tcp/ip al host ha fallado. java.net.connectexception: connection refused: connect



at other forums read perhaps authentication type used, authentication "sql authentication" wtf!!!!!

my tcp/ip enabled, via enabled, pipe enabled

please give me ray of light!!!!

one thing can try using ip address of server instead of server name in url database.

ted zimmerman

More discussions in Database Access

adobe