When trying to send an SMS from the bulk SMS screen I get a ‘Server’ error

By Julie Rodney

Q: Why do I get the following error when sending an SMS from the bulk SMS screen:

A: To fix this problem there are a few things to check:
1. Check that the database name and the name of the ODBC are the same in the Web configuration file.
2. Make sure you have the latest AllDBObjects Stored Procedure that includes the SMS Username column.
3. If you do not have the latest AllDBObjects stored Procedure you need to do the following:
3.1. Drop all the SMS Module tables in SQL Management Studio.
3.2. Drop all the Stored Procedures used by the SMS Module in SQL Management Studio.
3.3. Run the latest ALLDBObjects Stored Procedure on the database.