Error while using some Messagestats Webreports: Unexpected error while attempting to read from the database (0x80040217)
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
SELECT [Mailbox DN], [Originator], [Date], SUM([Size (KB)]) AS [Size(KB) (Total)], AVG([Size (KB)]) AS [Size (KB) (Avg)], COUNT(*) AS[_Count] FROM SELECT * FROM V_AuditMailboxMsgsSent) [_IntResult] WHERE(([Date] >= YYYY-MM-DD AND [Date] < YYYY-MM-DD)) GROUP BY [MailboxDN], [Originator], [Date] ORDER BY [Date] DESC, [Mailbox DN] ASC,[Originator] ASC
(0x80040217)
This problem is with the connection string to the database
To resolve this perform the following steps on the Messagestats Web Reporting Console (IIS Server)
1. Go to the Messagestats installation directory (usually C:\Program Files\Quest Software\Messagestats)
2. Right click QMSReports.udl and open with notepad
3. Add the following to the end of the string Language=us_english;
Example if the string is Provider=SQLOLEDB.1;Password=XXXX;Persist Security Info=True;User ID=UserName;Initial Catalog=MessageStatsReports;Data Source=ServerName;
After the change it should be
Provider=SQLOLEDB.1;Password=XXXX;Persist Security Info=True;User ID=UserName;Initial Catalog=MessageStatsReports;Data Source=ServerName;Language=us_english;
4. Save the file
5. Launch Web Reports again
N/A
