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:[EMAIL PROTECTED] Sent: Thursday, May 26, 2005 2:16 PM To: [email protected] 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 [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
