Also ensure you access it via IP and not machine name first.
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: D Suresh To: CF-Talk Sent: Fri May 25 06:41:53 2007 Subject: Re: DataSource Help- Very Urgent Thanks for your sugessions. I had check the SQL Server Utlity and TCP/IP is enabled and its default port is 1433 ....Still I am the same error... Kindly could any one help to Sort out this issue... >From: "Jim Wright" <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: CF-Talk <[email protected]> >Subject: Re: DataSource Help >Date: Thu, 24 May 2007 08:31:21 -0400 > >On 5/24/07, D Suresh <[EMAIL PROTECTED]> wrote: > > The Error msg is: > > > > Connection verification failed for data source: TestDB > > java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error >establishing > > socket. Connection refused: connect > > The root cause was that: java.sql.SQLException: [Macromedia][SQLServer >JDBC > > Driver]Error establishing socket. Connection refused: connect > > > >Make sure that you can reach the sql server on the correct port... >from the CF server, try: telnet yoursqlserver 1433 >at a command prompt...you should get a empty window if the port is open. >If you don't... >-is TCP/IP enabled on the sql server >-is there a firewall that would be blocking port 1433 >-is the SQL instance set up to listen on a port other than 1433 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
