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: cf-talk@houseoffusion.com >To: CF-Talk <cf-talk@houseoffusion.com> >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:279177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4