Hi Suresh, I had this issue with Railo and MX as well. The reason was that since I had service pack 2 of Windows XP installed I had to upgrade SQL Server to service pack 4 (although SP3 was sufficient). Something in the authorization checkings had changed...
Mark Drew had a blog entry on this one... http://www.markdrew.co.uk/blog/index.cfm/2006/11/14/Solving-MS-SQL-connection-refused-Errors-and-running-MS-SQL-on-a-MacBook-Pro Greetings / GrĂ¼sse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ D Suresh schrieb: > 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 > > > > > > >> From: "D Suresh" <[EMAIL PROTECTED]> >> Reply-To: cf-talk@houseoffusion.com >> To: CF-Talk <cf-talk@houseoffusion.com> >> Subject: RE: DataSource Help >> Date: Thu, 24 May 2007 12:13:34 +0000 >> >> sorry image not attached.... >> >> >> >>> From: "D Suresh" <[EMAIL PROTECTED]> >>> Reply-To: cf-talk@houseoffusion.com >>> To: CF-Talk <cf-talk@houseoffusion.com> >>> Subject: DataSource Help >>> Date: Thu, 24 May 2007 12:10:20 +0000 >>> >>> Hi All, >>> >>> I am unable to create Datasource in CF Server. It hrows the following >>> errors. >>> >>> >>> >>> Pls Help me ..! Thanks in advance. >>> >>> Ps: I had created a database in SQL Server 2000 as Test and I am using >>> >> the >> >>> same in CF server for creation. >>> >>> >>> >>> >>> Regards >>> Suresh >>> >>> _________________________________________________________________ >>> Shaadi.com Matrimonials. Register FREE! >>> http://www.shaadi.com/ptnr.php?ptnr=mhottag >>> >>> >>> >>> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4