Guest
2008-11-25T09:17:33Z
What does it mean ?

COM Exception raised
Function: CIncomingSMSProcessor::WorkerThread PollLoop
Description: Database Exception raised
Function: CActiveSMS::GetMessage
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
HResult: -2147217843

thanks
Support
2008-11-26T09:18:55Z
It would appear that you have re-configured ActiveSMS to use a SQL Server database (by default ActiveSMS uses an Microsoft Access database).

Please go to Control Panel -> Administrative Tools -> Data Source (ODBC) and check ODBC settings, you can use the 'Test Data Source...' button to test the settings.

In the ActiveSMS Console on the Queuing tab it is recommended that you have entered a username and password. It is recommended that you use a SQL Login.

NOTE: If you using Integrated Security this may not work because ActiveSMS run using a LOCALSYSTEM account. To use Integrated Security you must set the 'ActiveSMSServer' service to run under an appropriate user account. The service setting our changed at: Control Panel -> Administrative Tools -> Services.
Guest
2008-11-26T09:32:07Z
Actualy my sql server is on the same machine with activesms, i think it won't raise that problem
and i got this one too
COM Exception raised
Function: CHandset::PollLoop_PerminentConnection
Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
HResult: -2147467259

if i change into access database, it often raised this error:
COM Exception raised
Function: CHandset::PollLoop_PerminentConnection
Description: [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'SHPKLCLUNODE03'.
HResult: -2147467259

Thanks
ps: I'm using win2003k enterprise & sql server 2005 enterprise edition
Support
2008-11-27T06:54:49Z
This will be caused by problems connecting to the ActiveSMS database or the ActiveSMS Logging database.

You can check the connection to the ActiveSMS database as follows:
1) Open the ActiveSMS Console
2) Go to the Queuing tab
3) Click 'Test Connection'
4) If test fail then check Database Settings and ODBC Data Source settings

If you are using message logging to database you can check the ActiveSMS Logging database connection as follows:
1) Open the ActiveSMS Console
2) Go to the Logging tab
3) Click 'Setup Incoming Logging'
4) If logging to database then click 'Test Connection'
5) If test fail then check Database Settings and ODBC Data Source settings
6) Click 'Setup Incoming Logging'
7) If logging to database then click 'Test Connection'
8) If test fail then check Database Settings and ODBC Data Source settings
Guest
2008-11-27T09:34:45Z
All connection is "Ok",
because if the connection failed it should failed from the previous one not when activesms is running
thanks
Guest
2008-11-28T02:37:18Z
how came this error often run on my activesms ?

COM Exception raised
Function: CHandset::PollLoop_PerminentConnection
Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
HResult: -2147467259

Is activesms compatible with Sql server 2005 ? because when i used sql server 2000, i never found this problem
need your reply ASAP
thanks
Support
2008-12-01T10:25:48Z
Yes, ActiveSMS is compatible with 2005.

The error you are seeing is selecting to your database connection settings.

Please carry out the steps described above to test your database connections.
Guest
2008-12-02T02:40:55Z
All testing had been done, and it was connected to database
The error raised when activesms was on running position, not from the beginning
thanks