Skip to Content.
Sympa Menu

freetds - RE: [freetds] Domain Login Support, connecting to MSSQL issue

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Lowden, James K" <LowdenJK AT bernstein.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Domain Login Support, connecting to MSSQL issue
  • Date: Mon, 4 Aug 2003 14:36:12 -0400

> From: Chris Hettinger [mailto:chettinger AT encompas.com]
> Sent: August 4, 2003 12:39 PM
>
> I added the line : try server login = no to my freetds.conf

Per Frediano's suggestion, let's remove all "try ... login" lines from
freetds.conf. Instead, let's use the 'domain\username' form.

I think there's some possibility that FreeTDS is not reading the
freetds.conf you think it is, because

> # tsql -S ENCPPP -U chettinger
> Password:
> Msg 10019, Level 9, State 0, Server OpenClient, Line 0
> Server ENCPPP not found!
> There was a problem connecting to the server

indicates it didn't find a machine for servername 'ENCPPP'. No login was
attempted. You might want to "export TDSDUMPCONFIG=dumpconfig" and look at
the log.

> # tsql -S ENCPPP -U encompass.enc\chettinger
^^^^^^^^^^^^^^^^^^^^^^^^
I doubt this will work without single quotes. Most shells interpret the
backslash:

$ echo encompass.enc\chettinger
encompass.encchettinger
$ echo 'encompass.enc\chettinger'
encompass.enc\chettinger

> # tsql -S encppp.encompass.enc -U chettinger
> Password:
> Msg 18452, Level 14, State 1, Server , Line 0
> Login failed for user 'chettinger'. Reason: Not associated
> with a trusted SQL Server connection.
> Msg 20014, Level 9, State 0, Server OpenClient, Line 0
> Login incorrect.
> There was a problem connecting to the server

In this case, I think you bypassed freetds.conf completely. FreeTDS failed
its lookup of 'encppp.encompass.enc' and decided to try to connect to it as
a machine name (relying on compile-time defaults for any adjustable
settings). It succeeded, but had no indication you wanted a domain login.
This might work:

# tsql -S encppp.encompass.enc -U 'encompass.enc\chettinger'

if you configured --with-tds-version=7.0.

But as I said, the "Server ENCPPP not found!" means the freetds.conf files
that were consulted contained no entry (or an invalid entry) for ENCPPP.

--jkl


> On Fri, 1 Aug 2003 16:05:40 -0500, "Chris Hettinger"
>
> [ENCPPP]
> host = encppp.encompass.enc
> port = 1433
> tds version = 7.0
-----------------------------------------
The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above. If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the original
message. Please note that we do not accept account orders and/or instructions
by e-mail, and therefore will not be responsible for carrying out such orders
and/or instructions.






Archive powered by MHonArc 2.6.24.

Top of Page