Blackberry users can't get on the internet - MDS service not working
Blackberry users could use the internet up to about 1 month ago. I've been on leave, so it has been left until now.
We have Blackberry Professional Software version 18.104.22.168 - with Blackberry manager software version 22.214.171.124, and the Connection service lists itself as 126.96.36.199.
We are running this on Windows Server 2003 domain controller, with Exchange server 2003 installed, though we have an Exchange server 2007 in our environment as well.
The event viewer error is:
Event Type: Error
Event Source: BlackBerry MDS Connection Service
Event Category: None
Event ID: 15000
Time: 1:20:06 PM
<2010-09-08 13:20:06.905 GMT+08:00>::<MDS-CS_JABIRU_MDS-CS_1>:<ERROR>:<LAYER = SCM, EVENT = java.sql.SQLException: Specified driver could not be loaded due to system error 126 (SQL Server).>
I have logging on, and the MDAT log has the same error in many ways. See attached.
I have opened Blackberry Server Configuration and clicked the Test Database Login, and it returns successfully.
I have removed old versions of Java, and have made sure I have the latest version.
A microsoft kb article (not related to Blackberry) suggested that an error 126 (SQL Server) could come from sqlsvr.dll being missing from the system32 folder - I checked and I do not have it there, but I don't know where to get a replacement from.
I feel like I'm clutching at straws here, so time to ask for help.