[freetds] Domain vs Server Logins

Linus Linus at mccabe.nu
Wed Oct 8 08:20:38 EDT 2003


Hello!

With server login the SQL-Server manages user authentication internally. 
Domains logins, Windows manages user authentication and the server relies on 
Windows logins.

Not sure if either is more secure or not, but domain logins leaves you with 
one place to manage logins/passwords rather than two. On the other hand, most 
installations I know of have a single or a few database logins rather than 
one per user.

I've not managed to get domain logins to work with FreeTDS myself and afaik 
the code is quite new and untested.

/linus

On Wednesday 08 October 2003 16.16, James Reed wrote:
> Hi
>
> I have just installed freeTDS on a Sun system.  I had some problems with
> the following message:
>
> Login failed for user '(null)'. Reason: Not associated with a trusted > SQL
> Server connection.
>
> I played around with a few things and found that if I changed freetds.conf
> so that I used Server Logins instead of Domain Logins tsql would work.  Can
> someone explain the differences (advantages etc)?
>
> Thanks
> James
>
> _________________________________________________________________
> Se hvordan du blir SPAM/Søppelpost http://www.msn.no/computing/antispam
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds



More information about the FreeTDS mailing list