XP-SP2 issues with connecting CF to SQLServer

[dfwalton]

Just upgraded to SP2 on my XP development machine. I now cannot see the databse from within CF. Error I get is:

#  Connection verification failed for data source: sammco
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.

Usernames and passwords are consistent with the pre-upgrade state. Any ideas?

Thanks
David

 

[TruthInSatire]

It's probably the firewall that comes installed and by default "on" when you install SP2. My guess is it's blocking the sql server port. Try messing with the configeration of the Firewall. If all else fails you could turn it off. Chances are however you can change the settings. I believe you can access the settings by clicking start -> programs -> accessories -> system tools -> computer security (or whatever it's called i don't have xp on this machine.)

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)

 

[dfwalton]

Bombboy
Thanks for your reply. I fiddled with more tcp/ip ports yesterday than I ever want to see again.

In the end, I decided that I needed to also upgrade SQL server to SP 3a. I did that, then deleted and re-created my data sources in CF Admin, and it is now working.

Thanks again