thanks. I came across this. Have you looked at these already?
Why do I get java.sql.SQLException: "Network error IOException: Connection refused: connect" when trying to get a connection? The "Connection refused" exception is thrown by jTDS when it is unable to connect to the server. There may be a number of reasons why this could happen: The server name is misspelled or the port number is incorrect. SQL Server is not configured to use TCP/IP. Either enable TCP/IP from SQL Server's Network Utility app or have jTDS connect via named pipes (see the URL format for information on how to do this). There is a firewall blocking port 1433 on the server. To check whether TCP/IP is enabled and the port is not blocked you can use "telnet <server_host> 1433". Until telnet doesn't connect, jTDS won't either. If you can't figure out why, ask your network administrator for help. <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Thu, Sep 23, 2010 at 3:24 PM, Eddie Pequeno <[email protected]>wrote: > > The error message is: > "java.sql.SQLException: Network error IOException: Connection timed out: > connect" > > The JDBC URL is: > jdbc:jtds:sqlserver://XXX.XX.XXX.X:1433/master;useLOBs=false;ssl=require > with the X's replaced by an acutal IP address of course. > > The Driver Class is: > net.sourceforge.jtds.jdbc.Driver > > The connection string is: > ValidateServerCertificate=false;EncryptionMethod=SSL; > > -Eddie > > > > > > > > > > > --- On *Thu, 9/23/10, Ajas Mohammed <[email protected]>* wrote: > > > From: Ajas Mohammed <[email protected]> > Subject: Re: [houcfug] SSL Hell > To: [email protected] > Date: Thursday, September 23, 2010, 2:12 PM > > Just out of curiosity, what error are you getting? > > Also can you show an example of connection string please? > > <Ajas Mohammed /> > http://ajashadi.blogspot.com > We cannot become what we need to be, remaining what we are. > No matter what, find a way. Because thats what winners do. > You can't improve what you don't measure. > Quality is never an accident; it is always the result of high intention, > sincere effort, intelligent direction and skillful execution; it represents > the wise choice of many alternatives. > > > On Thu, Sep 23, 2010 at 2:55 PM, Eddie Pequeno > <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > > wrote: > > I used the keytool to verify that it was in the cert store. > > I also restarted the coldfusion service. > > Has anybody used the native CF8 SQL Server driver with SSL? > > -Eddie > > > --- On *Thu, 9/23/10, Eddie Pequeno > <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > >* wrote: > > > From: Eddie Pequeno > <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]>> > > > Subject: Re: [houcfug] SSL Hell > To: > [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > Date: Thursday, September 23, 2010, 11:29 AM > > > Affirmative. > > -Eddie > > --- On *Thu, 9/23/10, Mike G > <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > >* wrote: > > > From: Mike G > <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > > > Subject: Re: [houcfug] SSL Hell > To: > [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > Date: Thursday, September 23, 2010, 11:29 AM > > Did you put the SSL cert in the jrun cert store? > M > On Sep 23, 2010 11:12 AM, "Eddie Pequeno" > <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]>> > wrote: > > Yes. That's exactly right. > > > > But the connection must be sent through SSL. > > > > > > -Eddie > > > > > > --- On Thu, 9/23/10, Ajas Mohammed > > <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]>> > wrote: > > > > > > From: Ajas Mohammed > > <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > > > > Subject: Re: [houcfug] SSL Hell > > To: > > [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > > Date: Thursday, September 23, 2010, 11:01 AM > > > > > > Are talking about setting up a DSN connection to SQL Server from CF > administrator? > > > > <Ajas Mohammed /> > > http://ajashadi.blogspot.com > > We cannot become what we need to be, remaining what we are. > > No matter what, find a way. Because thats what winners do. > > You can't improve what you don't measure. > > Quality is never an accident; it is always the result of high intention, > sincere effort, intelligent direction and skillful execution; it represents > the wise choice of many alternatives. > > > > > > > > On Thu, Sep 23, 2010 at 11:54 AM, Eddie Pequeno > > <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]>> > wrote: > > > > Has anybody worked on getting CF8 to connect to an external MS SQL Server > db via SSL? > > > > Apparently CF9 handles it okay but CF8 is giving me fits. > > > > I'm not sure if the native driver for SQL Server on CF8 can handle SSL > connections so I tried changing to the JDBC jTDS driver but to no avail. > > > > -Eddie Pequeno > > > > > > > > > > > > > > > > -- > > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > > To unsubscribe, send email to > > [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > > For more options, visit http://groups.google.com/group/houcfug?hl=en > > > > -- > > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > > To unsubscribe, send email to > > [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > > For more options, visit http://groups.google.com/group/houcfug?hl=en > > > > > > > > > > -- > > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > > To unsubscribe, send email to > > [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > > For more options, visit http://groups.google.com/group/houcfug?hl=en > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to > [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > For more options, visit http://groups.google.com/group/houcfug?hl=en > > > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to > [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > For more options, visit http://groups.google.com/group/houcfug?hl=en > > > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to > [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> > For more options, visit http://groups.google.com/group/houcfug?hl=en > > > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en
