Greetings: Are both SQL servers named "(local)"? If so, I would try to specify a different name for one or the other. I suspect that ColdFusion server is trying to connect to the wrong server and cannot find the database.
Sincerely, Brooks Wilson Try not to become a man of success but rather to become a man of value. - Albert Einstein (1879-1955) Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] "Dusty Hale" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/04/2007 08:37 AM Please respond to discussion@acfug.org To <discussion@acfug.org> cc Subject RE: FW: [ACFUG Discuss] dsn's in cf admin Can't seem to find a solution that works so I'm going to develop with sql server express and dts the data back and forth with SQL Enterprise manager. I can set up dsn's with cf admin fine to sql express databases just not the sql 2000. Maybe there is a problem running multiple versions of sql on the same server. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Thursday, May 03, 2007 7:30 PM To: discussion@acfug.org Subject: Re: FW: [ACFUG Discuss] dsn's in cf admin sorry i read sql server 2005 for some reason... and im not using windows anymore so I should lay off "helping" on any windows related questions. On 5/3/07, Dusty Hale <[EMAIL PROTECTED]> wrote: > > > Of course it works fine when setting up through windows control panel. > > ________________________________ > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty > Hale > Sent: Thursday, May 03, 2007 4:54 PM > To: discussion@acfug.org > Subject: [ACFUG Discuss] dsn's in cf admin > > > > > > > I'm used to setting up dsn's for SQL Server with the server name "(local)" > when in fact the server instance is local. However, I just installed > SQL Server 2000 Eval on my laptop and am trying to set up a dsn to a > database I just created. I've verified the server name is (local) and > I tried that and also the IP 127.0.0.1 > > > > (CF 7 and SQL 2000) > > > > I get this error (in cf admin dsn section) when using the ip: > > > > Connection verification failed for data source: tester > 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 > > > > > I get this error when using (local): > > > > Connection verification failed for data source: tester > java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error > establishing socket. Unknown host: (local) The root cause was that: > java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error > establishing socket. Unknown host: (local) > > > > > If anyone could tell me what I'm doing wrong, I would greatly appreciate it. > I also have SQL Server 2005 Express running on the same machine with a > different instance name and setting dsn's to that one works fine. > > > > thx > > > > Dusty > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > ------------------------------------------------------------- > ------------------------------------------------------------- > > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > ------------------------------------------------------------- -- Steven Ross web application & interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------ ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
<<image/gif>>