I've had a server running for the last couple of months and earlier today it died, i managed to get Service Pack 2 on it, and now it will start but nothing will interface with it,
especially not coldfusion
SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
though when i use ODBC and i set a new DSN
if i use Windows Authentication, it goes through, and i test the source and it says succesful
though if i try and use SQL Authentication it says
Connection Failed :
SQL State : '28000'
SQL Server Error : 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for 'username'. Reason : User not associated with a trusted SQL connection