I’ve gone through a barrage of different web articles on setting up an external cdr database (using MS SQL Server). I tried using the settings in “Advanced Settings” to set this up, but I’m getting a weird error
[FATAL] SQLSTATE[HY000]  Lost connection to MySQL server at ‘reading initial communication packet’, system error: 104 SQLSTATE[HY000]  Lost connection to MySQL server at ‘reading initial communication packet’, system error: 104
Some articles have suggested recompiling Asterisk and setting up ODBC support. I guess I’m a little afraid to do that on a FreePBX distro. Anyone have any ideas?
No. You can’t get there from here without a lot of new code.
That’s what we’ve been trying to tell you. You can use MySQL, but that it completely different than MS SQL.
It’s like asking if I can put a Mercedes body on a Citroen. If you have the right tools and experience, you can probably get it done. If you don’t have that kind of experience, it’s not likely to end up what you are hoping for.