We have a development database running on a little windowsXP Pro machine that's hummed along quite nicely. Then today, we ran SP2 because we did a monthly reboot and it reminded us. We didn't change any settings and when it came back up we just cut off the Windows Firewall, the Virus checker, etc thinking, "well, we'll just cut it all off". We really didn't fear it because this little machine does *one* thing...run SQL server in-house for testing and development.
Now the server running CF is throwing errors and all the SQL server datasources that are normally pointing at the IG-SQL (Interactive Group SQL...clever, eh?) and working are all being refused with the following error: Connection verification failed for data source: TestSQL []java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect This is when we simply go in and submit the datasource with all the correct info...'cause nothing's changed...well...*technically*... For what it's worth, I can look at "IG-SQL" on my machine with my Enterprise Manager and all is well. I can see my instance of it, it expands, I see all the tables, etc...so I know the machine's up and working just dandy. I can use Enterprise Manager locally on the Machine...and on my machine and see the server hunky dorey... Anyway, I just thought one of you guys might have seen it, and could go, "oh yeah, this happened to us and we #solution#". Thank ye ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
