Connecting to web page and SQL 2005 from windows 2000
-
I've just put a system live today and I'm having issues connecting to SQL 2005 from w2k. SQL 2005 (64 bit with latest service pack) is on windows 2008, 64 bit server. Everything was tested before going live and worked fine. The only difference now is that there is a firewall between the systems. From the w2k box, I cannot connect to SQL 2005 via SSMS. Interestingly, there is also a problem actually using the website from the same computer. When submitting a form, the system just hangs. This happens both on IE and firefox, so I'm guessing its not a browser issue. Error message from SSMS is tcp error 0, the specified network is no longer available. SQL error : 64. Google has not thrown up any ideas so far (and I've been looking for about 6 hours now) I can access the website from XP laptop and also from W2k3 server. I have tried installing SQL 2005 on laptop, but I had 2008 trial on it some months ago and it seems some remnants of that are causing the install to fail, but thats another story.... Also of note, I CAN connect to the SQL 2005 box from w2k using Sql 2000 query analyser OK and if I change the connection string on dev system on w2k box to the live SQL server, it connects fine. Has anyone experienced this before? Any ideas on workarounds / fixes