Cant connect to server

Hey,
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

Coldfusion says
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

any ideas?Is your sql instance set up for windows only authentification or mixed-mode ?|||Originally posted by rnealejr
Is your sql instance set up for windows only authentification or mixed-mode ?

its ok
sorted it now, it was for SQL Authentication, not mixed or windows

i rebuilt the registry and it worked