I have been trying to get our Asterisk server (Business Edition based on 1.2) to record the cdr to MSSQL(version 2005).
We have several sql servers and I’m trying to connect to one of them through FreeTDS/unixODBC. I can connect to any of the servers using the tsql utility that comes with FreeTDS but, even though all the servers run in mixed mode, it will only work with a domain account.
Howevere I can’t get it to work with a domain account through unixODBC though. Has anyone had any expierence with this? All the sql servers are running on windows server 2003 and are part of a domain. The Windows accounts are active directroy accounts.
Any help/pointers would be greatly appreciated.