[freetds] Freetds connecting to SQL server running under a domain account

[Ganesh Ranganathan]

Hi ,

In my company we have two servers. In one SQL Service is running the local
system account and in another it is running under a domain account

I am able to connect freetds to the one running under the local system
account but it doesnt work when the Sql Server service is running under a
domain account.

In the first case the SPN (Server principal name is registered to the host
itself but in second case it is registered to the domain account under
which it runs. any pointers on how to solve

Thanks
Ganesh

[Randy Syring]

I think you want to use Kerberos:

http://www.freetds.org/userguide/kerberos.htm

But unfortunately, I don't know much more than that.

*Randy Syring*
Husband | Father | Redeemed Sinner

/"For what does it profit a man to gain the whole world
and forfeit his soul?" (Mark 8:36 ESV)/

Post by Ganesh Ranganathan
Hi ,
In my company we have two servers. In one SQL Service is running the local
system account and in another it is running under a domain account
I am able to connect freetds to the one running under the local system
account but it doesnt work when the Sql Server service is running under a
domain account.
In the first case the SPN (Server principal name is registered to the host
itself but in second case it is registered to the domain account under
which it runs. any pointers on how to solve
Thanks
Ganesh
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds