[freetds] domain login to mssql7 - login failed for user null
- not associated with a trusted sql server connection
Paul Munn
pmunn at munn.com
Mon Jan 6 10:40:27 EST 2003
Hello everyone.
Thank you for your suggestions. It was, remarkably, a simple mistake of
trying to use the wrong password to log in!
Thanks for lending a hand anyway!
Frediano Ziglio wrote:
> Il sab, 2003-01-04 alle 16:43, Paul Munn ha scritto:
>
>>Hello folks,
>>
>>I went back over the past few months of the list archives and didn't see
>>info on this, so here goes.
>>
>>I've installed the cvs snapshot of freedts and am attempting to use the
>>tsql program to talk to my mssql 7 server on the LAN. I built it with
>>ssl to support domain logins.
>>
>
>
> --with-ssl ?? Is a quite old option... 0.60 use it...
>
>
>>Here's the profile in the config file, with the IP address and domain
>>obscured for public posting.
>>
>>[dev01]
>> host = the_host_ip_address
>> port = 1433
>> tds version = 7.0
>> try domain login = yes
>> try server login = no
>> nt domain = MYCOMPANYDOMAIN
>>
>
>
> Seem correct...
>
>
>>and here's the result of a tsql -S dev01 -U myusername followed by me
>>hand-typing my password:
>>
>>Msg 18452, Level 14, State 1, Server , Line 0
>>Login failed for user '(null)'. Reason: Not associated with a trusted
>>SQL Server connection.
>>Msg 20004, Level 9, State 0, Server OpenClient, Line 0
>>Read from SQL server failed.
>>Msg 20014, Level 9, State 0, Server OpenClient, Line 0
>>Login incorrect.
>>There was a problem connecting to the server
>>
>>The website documentation suggests I set a security checkbox on the
>>server via Enterprise Manager, but it's already set in the "Windows and
>>SQL Server" position.
>>
>>Any takers?
>>
>
>
> Some try:
> - try setting "nt domain" on global
> - try calling tsql with full domain
> # tsql -S dev01 -U 'MYCOMPANYDOMAIN\myusername'
>
> Try setting TDSCONFIGDUMP to a file name, reissuing tsql command and see results..
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
--
Paul Munn | pmunn at munn.com | http://www.farbot.com/
More information about the FreeTDS
mailing list