Jul 13, 2016

0 Freetds sqlstate[01002]

In case of error : Not connected SQLSTATE[01002] Adaptive Server connection failed (severity 9)

Connect to MSSQL server from linux server :

tsql -S server.com -U username

Output : 

locale is "en_GB.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Msg 18487 (severity 14, state 1) from server.com Line 1:
"Login failed for user 'username'.  
Reason: The password of the account has expired."
Error 20002 (severity 9):
Adaptive Server connection failed
There was a problem connecting to the server

Change password or uncheck password expiry option in MSSQL server.


Post a Comment