[freetds] BCP/ISQL Trusted connection? [NC]

Frediano Ziglio freddy77 at gmail.com
Wed Oct 28 19:04:59 EDT 2009


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 at 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



More information about the FreeTDS mailing list