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

Cedric ROUVRAIS cedric.rouvrais at sgcib.com
Tue Oct 27 13:22:42 EDT 2009


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



                                                                           
             Cedric                                                        
             ROUVRAIS/us/socge                                             
             n                                                          To 
                                               FreeTDS Development Group   
             10/27/2009 01:08                  <freetds at lists.ibiblio.org> 
             PM                                                         cc 
                                                                           
                                                                   Subject 
                                               BCP/ISQL Trusted            
                                               connection? [NC](Document   
                                               link: Cedric ROUVRAIS)      
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           



Hi guys,

The microsoft utilities have the ability to use the nt credentials of the
current user to connect to the SQL Server (e.g. bcp -T option). Is this
possible with FreeTDS? I ask the question because our scripts have the
passwords in them, if we can switch to trusted, there will be no need to
put the passwords in.

Thanks,

Cedric


*************************************************************************
This message and any attachments (the "message") are confidential, intended 
solely for the addressee(s), and may contain legally privileged information.  
Any unauthorised use or dissemination is prohibited.  E-mails are susceptible 
to alteration.  Neither SOCIETE GENERALE nor any of its subsidiaries or 
affiliates shall be liable for the message if altered, changed or falsified.
*************************************************************************




More information about the FreeTDS mailing list