freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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: Wed, 28 Oct 2009 10:54:02 +0100
2009/10/27 Cedric ROUVRAIS <cedric.rouvrais AT sgcib.com>:
> Just a FYI, when I try the following:
>
> bash-3.2$ bcp db..table out table.dat -S MSNYCACRT01 -U AME\\CRouvrai -P ''
> -c -t"|"
> Msg 18452, Level 14, State 1
> Server 'MPKASSQL02DV\MSNYCCRSD02', 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
>
> Can't connect to server "MSNYCACRT01".
>
> Thanks,
>
> Cedric
>
If "AME" is your domain, "CRouvrai" is your username and "" is your
password should work. Keep mind that windows use the account stored
when you login. To get similar behaviour under Unix you have to
configure kerberos support with pam saving account in your store. The
command in this case will be
bash-3.2$ bcp db..table out table.dat -S MSNYCACRT01 -U '' -P ''
freddy77
-
Re: [freetds] BCP/ISQL Trusted connection? [NC],
Cedric ROUVRAIS, 10/27/2009
-
Re: [freetds] BCP/ISQL Trusted connection? [NC],
Frediano Ziglio, 10/28/2009
-
Re: [freetds] BCP/ISQL Trusted connection? [NC],
Cedric ROUVRAIS, 10/28/2009
-
Re: [freetds] BCP/ISQL Trusted connection? [NC],
Frediano Ziglio, 10/28/2009
- Re: [freetds] BCP/ISQL Trusted connection? [NC], Cedric ROUVRAIS, 10/28/2009
-
Re: [freetds] BCP/ISQL Trusted connection? [NC],
Frediano Ziglio, 10/28/2009
-
Re: [freetds] BCP/ISQL Trusted connection? [NC],
Cedric ROUVRAIS, 10/28/2009
-
Re: [freetds] BCP/ISQL Trusted connection? [NC],
Frediano Ziglio, 10/28/2009
Archive powered by MHonArc 2.6.24.