Skip to Content.
Sympa Menu

freetds - Re: [freetds] Connection/Password Error

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Derrick Betts" <derrick AT blueaxis.com>
  • To: <FreeTDS AT lists.ibiblio.org>
  • Subject: Re: [freetds] Connection/Password Error
  • Date: Mon, 26 Aug 2013 20:21:41 -0600

Found the problem:

It was a simple issue of quotes. The password argument
needed single quotes around it. Once the single quotes were added to the
password, everything worked as expected.



Derrick



From: Derrick Betts [mailto:derrick AT blueaxis.com]
Sent: Monday, August 26, 2013 12:20 PM
To: FreeTDS AT lists.ibiblio.org
Subject: Connection/Password Error



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





Archive powered by MHonArc 2.6.24.

Top of Page