Here's what comes to mind for me.... Did you test it by telneting from the web server? I also leave TCP/IP and "shared" enabled, but disable named pipes and any other network libraries (using the sql config tool).
Also make sure that you create a user name for CF using "standard" security (not AD security) and make sure that when you create it you set it so that the password does not need to be changed on first usage. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Priya Koya [mailto:priya23...@gmail.com] Sent: Saturday, February 14, 2009 1:08 PM To: cf-talk Subject: Re: Unable to create Datasource ColdFusion8 Yes, I did.. Set tje port 1433..i tested with telnet localhost 1433 .. its connectivity is working fine On Sat, Feb 14, 2009 at 1:51 PM, TJ Downes <koldfu...@gmail.com> wrote: > > By default the SQL Server Express port is dynamic, meaning i changes. > You need to use the SQL Server configuration tool to set a static port > and use the port number, generally 1433, in the DSN admin interface. > Have you done this? > > TJ Downes > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4