Heya, I went through this process once.. and it involved many hours of trying to connect, then examining the firewall logs to see what port attempts were made on. Then open that port and try again.
I don't know the details of exactly what had to get opened, but this might be a strategy for you to try to work it out.. bye! Friday, July 2, 2004, 4:43:23 PM, you wrote: GL> Thanks. That's what we are doing now. What I want to know is what ports GL> need to be open. GL> George >>>> [EMAIL PROTECTED] 2/07/04 16:37:13 >>> GL> Hi George, GL> I'm tempted to guess that your DMZ has public IPs, whilst your LAN has GL> got private ones, in which case you will need to forward the database GL> ports of your LAN gateway to the private IP database server? This kind GL> of set up could be quite complicated, especially if you've never messed GL> with firewalls and such before. GL> Regards, GL> J GL> -----Original Message----- GL> From: George Lu [mailto:[EMAIL PROTECTED] GL> Sent: Friday, 2 July 2004 4:07 PM GL> To: CFAussie Mailing List GL> Subject: [cfaussie] [OT] DMZ GL> Hi All, GL> We're going to set up an extranet environment. One option is to place GL> our ColdFusion server under DMZ (DeMilitarize Zone) and the database GL> server on the LAN. We try to test the connection between the CF server GL> and the db server without open UDP and most of TCP/IP ports. However, GL> the connection always fail no matter how many tcp/ip ports open. I've GL> tried to put 1839 or 1433 in the Data Source setting. Does anyone have GL> similar situation? Could someone give me an idea what's happening? GL> Here was the error message when I tried to verified the data source: GL> Connection verification failed for data source: Intranet GL> []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The GL> requested instance is either invalid or not running. GL> The root cause was that: java.sql.SQLException: [Macromedia][SQLServer GL> JDBC Driver]The requested instance is either invalid or not running. GL> Thank you in advanced.GeorgeGeorge Lu GL> Web Developer/Engineer GL> Information Systems and Technology GL> Adult Multicultural Education Services GL> 4/255 William Street GL> Melbourne, Vic 3000 GL> ------------------------------------------ GL> Direct: 03 9926 4706 GL> Fax: 03 9926 4695 GL> Email: [EMAIL PROTECTED] GL> Web: www.ames.net.au GL> ------------------------------------------ GL> --- GL> You are currently subscribed to cfaussie as: GL> [EMAIL PROTECTED] GL> To unsubscribe send a blank email to GL> [EMAIL PROTECTED] Aussie Macromedia Developers: GL> http://lists.daemon.com.au/ GL> AMES (Adult Multicultural Education Services) GL> www.ames.net.au GL> Disclaimer GL> ********************************************************************** GL> This email and any attachments may be confidential. GL> If received in error, please contact us and delete all copies. GL> Before opening or using attachments you should check them for viruses GL> or defects. GL> Regardless of any loss, damage or consequence, whether caused by the GL> negligence of the sender or not, resulting directly or indirectly from GL> the use of any attached files our liability is limited to resupplying GL> any affected attachments. GL> Any representations or opinions expressed are those of the individual GL> sender, and not necessarily those of Adult Multicultural Education GL> Services (AMES). GL> ********************************************************************** GL> --- GL> You are currently subscribed to cfaussie as: GL> [EMAIL PROTECTED] GL> To unsubscribe send a blank email to GL> [EMAIL PROTECTED] Aussie Macromedia Developers: GL> http://lists.daemon.com.au/ --- GL> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] GL> To unsubscribe send a blank email to GL> [EMAIL PROTECTED] Aussie Macromedia Developers: GL> http://lists.daemon.com.au/ GL> AMES (Adult Multicultural Education Services) GL> www.ames.net.au GL> Disclaimer GL> ********************************************************************** GL> This email and any attachments may be confidential. GL> If received in error, please contact us and delete all copies. GL> Before opening or using attachments you should check them for viruses GL> or defects. GL> Regardless of any loss, damage or consequence, whether caused by the GL> negligence of the sender or not, resulting directly or indirectly from GL> the use of any attached files our liability is limited to resupplying GL> any affected attachments. GL> Any representations or opinions expressed are those of the individual GL> sender, and not necessarily those of Adult Multicultural Education GL> Services (AMES). GL> ********************************************************************** GL> --- GL> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] GL> To unsubscribe send a blank email to [EMAIL PROTECTED] GL> Aussie Macromedia Developers: http://lists.daemon.com.au/ ----------------------- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
