[freetds] Connection/Password Error

Derrick Betts derrick at blueaxis.com
Mon Aug 26 14:19:48 EDT 2013


I'm recently installed FreeTDS v 0.91 on RedHat 6.1. I'm attempting to
connect to MSSQL 2005.

 

On the command line, I can connect just fine using this:

                tsql -S MyMSSQLServer -U sa

 

                I am then prompted for the password. I enter the password,
and the system connects and I can run SQL commands against the DB. All is
well.

 

However, when I attempt to connect this way:

                tsql -S MyMSSQLServer -U sa -P specialpassword

 

                I get a "Login failed for user 'sa'. Obviously the password
I'm using for the command line argument is identical to the password I'm
using when prompted for the password.

 

I've searched through as much documentation as I can find, but can't figure
out how to setup the *.conf files or configure FreeTDS any differently so
that the password can be passed as a command line argument and connect. Any
ideas what I can try next?

 

Thanks,
Derrick



More information about the FreeTDS mailing list