Yes, I think I saw that in the jTDS site. Thanks for the suggestion though Ajas. Usually I connect to SQL Server via the native driver with no problem it's the SSL factor that is throwing a wrench in the mix. I realize that not many people actually do this but I'm still surprised by how little info there is about it online. -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:31 PM 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]> 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]> wrote: From: Eddie Pequeno <[email protected]> Subject: Re: [houcfug] SSL Hell To: [email protected] Date: Thursday, September 23, 2010, 11:29 AM Affirmative. -Eddie --- On Thu, 9/23/10, Mike G <[email protected]> wrote: From: Mike G <[email protected]> Subject: Re: [houcfug] SSL Hell To: [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]> wrote: > Yes. That's exactly right. > > But the connection must be sent through 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, 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]> > 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] > 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 -- 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 -- 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
