[freetds] NT Authentication Failing for an ODBC-Only Configuration [NC]

Cedric ROUVRAIS cedric.rouvrais at sgcib.com
Mon Jul 13 15:15:24 EDT 2009


Hi Gil,

Quick question did you escape the \ ? On unix/linux systems you need to
escape it. domain\\username

a++ Cedric



|------------------------------                                            
|            "Gil Darves"                                                  
|            <gil at darves.net>                                              
|            Sent by:                                                      
|            freetds-bounces at l                                             
|            ists.ibiblio.org                                              
|                                                                          
|                                                                          
|            07/13/2009 03:11                                              
|            PM                                                            
|                                                                          
|                                                                          
|            Please respond to                                             
|                 FreeTDS                                                  
|            Development Group                                             
|            <freetds at lists.ib                                             
|               iblio.org>                                                 
|                                                                          
|                                                                          
                                                                           
                                                                           
                                                                        To 
                                               <freetds at lists.ibiblio.org> 
                                                                        cc 
                                                                           
                                                                   Subject 
                                               [freetds] NT Authentication 
                                               Failing for an ODBC-Only    
                                               Configuration               
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Hello,



I am able to connect to a SQLServer 2008 database using SQL Authentication
but am receiving a SQLConnect error when attemping a domain\username
connection for an ODBC-Only Configuration.



Here is the sequence.



1.       I implemented an installation on a Red Hat Enterprise Linux Server
release 5.2 (Tikanga) by following Peter Harvey's "How to use unixODBC with
FreeTDS".

2.       I have not configured the /usr/local/etc/freetds.conf
configuration
file.

3.       I am able to connect using NT Authenticaion using FreeTDS tsql
utility

tsql -H 10.7.22.22 -p 1433 -U 'domain\gdarves'

4.       I am able to connect using isql using sql account

isql MSSQLTestServer gdarves mypassword

5.       But when I attempt the following

Isql MSSQLTestServer domain\gdarves mypassword

                                       'domain\gdarves' mypassword

                                     "domain\gdarves" mypassword



The message [ISQL] ERROR: Could not SQLConnect





Here is my odbcinst.ini configuration file located at /usr/local/etc



[FreeTDS]

Description     = freetds v0.82

Driver      = /usr/local/lib/libtdsodbc.so

UsageCount      = 2



Here is my .odbc.ini config file located in my home directory



[MSSQLTestServer]

Driver      = FreeTDS

Description     = zGilSandbox

Trace       = No

Server      = 10.7.22.22

Port        = 1433

Database        = zGilSandbox



Here is my compile-time configuration parameters

gild (dev) bin: tsql -C

Compile-time settings (established with the "configure" script)  Version:
freetds v0.82

 freetds.conf directory: /usr/local/etc

 MS db-lib source compatibility: no

 Sybase binary compatibility: no

 Thread safety: yes

  iconv library: yes

 TDS version: 8.0

  iODBC: no

 unixodbc: yes





I attempted to diagnose using the osql utility. Here is the output:



gild (dev) ~: osql -S MSSQLTestServer -U 'dm\gdarves' -P mypassword!

looking for odbc.ini and odbcinst.ini in /usr/local/etc

        reading "/home/v-gil.darves/.odbc.ini"

[MSSQLTestServer] found in "/home/v-gil.darves/.odbc.ini"

found this section:

        [MSSQLTestServer]

        Driver          = FreeTDS

        Description             = zGilSandbox

        Trace           = No

        Server          = 10.7.22.22

        Port            = 1433

        Database                = zGilSandbox



looking for driver for DSN [MSSQLTestServer]

driver "FreeTDS" found for [MSSQLTestServer] in .odbc.ini

found driver named "FreeTDS"

FreeTDS is not a readable file

looking for entry named [FreeTDS] in /usr/local/etc/odbcinst.ini

driver "/usr/local/lib/libtdsodbc.so" found for [FreeTDS] in odbcinst.ini

/usr/local/lib/libtdsodbc.so is a readable file

"Server" found, not using freetds.conf

FreeTDS servername is "10.7.22.22"

10.7.22.22 has address Host 22.22.7.10.in-addr.arpa not found: 3(NXDOMAIN)



 DSN: MSSQLTestServer

 Server's hostname: 10.7.22.22

                       Address: Host

       22.22.7.10.in-addr.arpa: not

                        found:: 3(NXDOMAIN)

                        Driver: /usr/local/lib/libtdsodbc.so



Attempting connection as dm\gdarves...

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source

[37000][unixODBC][FreeTDS][SQL Server]Login failed. The login is from an
untrusted domain and cannot be used with Windows authentication.

[ISQL]ERROR: Could not SQLConnect





Note: the osql utility fails when I use the sql authenticated account as
well!!!. Same message about in-addr.arpa not found.



Please advise.



Thank you,

Gil Darves







_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



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