can you go and try to create the ODBC connection profile from scratch. I had similar issues with a Sybase server, in the same situation (a password had changed). Recreating the ODBC connection somehow cleared the problem.
Yes, have already tried that and also have tried the ODBC setup on 2 other PC's, one new with same result.
In the DB logs I see the account is failing with bad password but I'm not seeing an entry in the log each time. I know my password is right as I've changed it a few times trying to fix this issue.
Most of the entries in the DB Log are Maximum connections of 30 ... the command is show uccx tech db log message to see this log.
A packet capture on the UCCX server shows the request come in to the server from the PC's but the pcap doesn't really reveal what is going on. I see UCCX ACK the TCP packet but there is nothing really in packet capture saying why it had problem.
just out of curiosity, could you perhaps use a different means of connecting to the DB server? For instance, using a JDBC connection? Perhaps you could try this: https://supportforums.cisco.com/document/64301/squirrel-sql-client-setuppdf
EDIT: this is for testing only, I am not expecting you to switch to JDBC from ODBC, I just want to see whether there's something wrong with ODBC or it is really about the password. Thanks and sorry for the confusion.
Erick, we were finally able to find the resolution for us. The DNS servers on UCCX were pointed to retired DNS servers. We updated the DNS settings to valid servers and were able to connect to one of the UCCX servers. Then we discovered that there were reverse-lookup entries with different hostnames for the same IP address on the DNS server. We removed the invalid entry and the ODBC connection to the second UCCX server worked like a charm.
Make sure you can resolve your other UCCX servers and ODBC servers from UCCX.
admin:utils network host 10.10.10.15 Local Resolution: 10.10.10.15 resolves locally to UCCX01.test.net
External Resolution: 184.108.40.206.in-addr.arpa domain name pointer uccx01.test.net. admin: admin: admin: admin: admin:utils network host uccx01 Local Resolution: uccx01.test.net resolves locally to 10.10.10.15 (UCCX01.test.net)
External Resolution: uccx01.test.net has address 10.10.10.15
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...