[Asterisk-Users] tds_CDR and MS SQL Server troubleshooting

[Colin Anderson]

In the SQL server MMC, you can expand SQL server > Management > Process Info
and see if your defined user is listed in there after you try to hit SQL
server. If not, it is most certainly a rights problem. 

Quick and dirty way to determine if it's a rights problem is to use the sql
server SA account as the login. If it works, then it's a rights problem. 

hth

-----Original Message-----
From: PA [mailto:taihome at earthlink.net]
Sent: Thursday, May 26, 2005 2:16 PM
To: asterisk-users at lists.digium.com
Subject: [Asterisk-Users] tds_CDR and MS SQL Server troubleshooting


I am trying to get * to write CDR records to an MS SQL table.  I am used the
freeTDS set up (not using UNIX ODBC), and it appears to be making the
connection to the database, but I make a call, I get this error:

WARNING[3369]: cdr_tds.c:180 tds_log: Reconnected to SQL database.
ERROR[3369]: cdr_tds.c:191 tds_log: Failed to insert Call Data Records into
SQL database.

I've assigned all rights to the cdr table in SQL to the user.  I am not sure
how to troubleshoot this from this point.  Does anyone know else these
errors are?  Thanks for any direction.

Phil


_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users