I have a similar issue,
This is the error i'm getting in my smsprov.log
[1B54][Tue 03/11/2008 13:48:48]:Execute SQL =select all
SMS_SiteDetailSummarizer.DatabaseFree,SMS_SiteDetailSummarizer.Errors,SMS_SiteDetailSummarizer.Infos,SMS_SiteDetailSummarizer.SiteCode,SMS_SiteDetailSummarizer.SiteName,SMS_SiteDetailSummarizer.Status,SMS_SiteDetailSummarizer.TallyInterval,SMS_SiteDetailSummarizer.TransFree,SMS_SiteDetailSummarizer.Version,SMS_SiteDetailSummarizer.Warnings
from vSMS_SiteDetailSummarizer AS SMS_SiteDetailSummarizer where
SMS_SiteDetailSummarizer.TallyInterval = "0001128000100008"
[1B54][Tue 03/11/2008 13:48:48]:Results returned: 1 of 2
> Are you in Advanced or Standard security mode?
>
> Check the smsprov.log for errors.