> well i am trying to make a regular connection in cf admin to > sql server 2000. > > i can do it with. > Driver: ODBC Socket > but not with > Driver: Microsoft SQL Server > > Connection verification failed for data source: master An > exception occurred when executing method verifydatasource. > The cause of this exception was that: > coldfusion.sql.Executive$ConnectionVerificationFailedException: > java.sql.SQLException: [Macromedia][SQLServer JDBC > Driver]Error establishing socket to host and port: > TARDIS:1433. Reason: Connection refused: connect.
I would bet that SQL Server is not listening on TARDIS:1433. Perhaps SQL Server isn't set up to use that specific port, or perhaps it's not set up to use TCP/IP at all, or perhaps the name TARDIS doesn't resolve correctly from the CF server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
