Skip to Content.
Sympa Menu

freetds - Re: [freetds] BCP/ISQL Trusted connection? [NC]

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] BCP/ISQL Trusted connection? [NC]
  • Date: Thu, 29 Oct 2009 00:04:59 +0100

2009/10/28 Cedric ROUVRAIS <cedric.rouvrais AT sgcib.com>:
> Hi,
>
> I am getting the following issue on a linux box:
>
> bash-3.2$ bcp formdb..v_fxo_cre_posted out v_fxo_cre_posted.dat -c -t"|" -S
> MSNYCRDFP01 -U '' -P ''
> Msg 20002, Level 9
> Adaptive Server connection failed
>
> Can't connect to server "MSNYCRDFP01".
>

kerberos setup is not so easy... what says "klist" command. I did
tests using "kinit username@ad_domain" where username is my domain
username while ad_domain is active directory dns domain (uppercase).

> If I put my NT user account and password I get the following
>
> bash-3.2$ bcp formdb..v_fxo_cre_posted out v_fxo_cre_posted.dat -c -t"|" -S
> MSNYCRDFP01 -U 'NT_Domain\\NT_login' -P 'passwordOfAccount'
> Msg 18452, Level 14, State 1
> Server 'VSNYCINSQL30\MSNYCCRS01', Line 1
>        Login failed. The login is from an untrusted domain and cannot be
> used with Windows authentication.
> Msg 18452, Level 14
> General SQL Server error: Check messages from the SQL Server
>
> Msg 20002, Level 9
> Adaptive Server connection failed
>

Are you using 0.82 ? There is a post 0.82 patch which fix an NTLM2 issue.

> Can't connect to server "MSNYCRDFP01".
>
> However if I type id
>
> bash-3.2$ id
> uid=35677(crouvrai)
>
> Where crouvrai is in fact my NT login without the domain.
>
> Thanks for any insight, I also forwarded your response to the unix dudes
> who configured the server, they haven't come back yet.
>
> Cedric
>

bye
freddy77




Archive powered by MHonArc 2.6.24.

Top of Page