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.


0 comments :

Post a Comment

Comment: