When attempting to run an Archive Manager gathering using Messagestats 6.6 and Archive Manager Report Pack 1.3.1 the gathering starts then either fails at 41% or simply disappears.
Reviewing the Task Log the following messages are contained:
Error running stored procedure -2147217900
Error running stored procedure Server DB\SQL2005 is not configured for DATA ACCESS.
Error running stored procedure PR_AMRP_PopulateMailboxSummary
Issuerelated to a change made in the release of version 4.1.1of Quest Archive Manager database.
Run the following SQL Stored Procedure using the following steps:
1 - Open SQL Management Studio and connect to the SQL Server where the MessageStats Database is located.
2 - Open New Query
3 - Paste the query below in the new query window, and replace the AM Database with the Actual SQL server name where the Archive Manager database resides and then hit the Execute Button. ( Make sure the Archive Manager Database Server name is within the quotes)
EXEC sp_serveroption @server = ‘AM Database’
,@optname = ‘DATA ACCESS’
,@optvalue = ‘TRUE’
4. Run the Archive Manager Gathering.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center