При создании любой подписки для файлов любых форматов (и в том числе, подписка не на почту, а в папку), после нажатия кнопки "ОК" пишется сообщение:

Произошла внутренняя ошибка на сервере отчетов. Дополнительные подробности см. в журнале ошибок. (rsInternalError)

В логах Windows написано
Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary extension.

В логах сервера отчётов:




w3wp!library!5!05/27/2008-09:45:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: Действие не поддерживается в собственном режиме сервера отчетов., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: Действие не поддерживается в собственном режиме сервера отчетов.
w3wp!extensionfactory!5!05/27/2008-09:45:11:: e ERROR: Exception caught instantiating Report Server DocumentLibrary report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider' threw an exception. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: Действие не поддерживается в собственном режиме сервера отчетов.
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig).
w3wp!library!8!05/27/2008-09:45:26:: Call to GetReportParametersAction(/ATM monitoring/Динамика).
w3wp!library!8!05/27/2008-09:45:27:: Call to ListSchedulesAction().
w3wp!library!5!05/27/2008-09:45:27:: Call to GetSystemPropertiesAction().
w3wp!library!1!05/27/2008-09:45:39:: Call to GetPropertiesAction(/ATM monitoring/Динамика, PathBased).
w3wp!library!1!05/27/2008-09:45:39:: Call to GetSystemPermissionsAction().
w3wp!library!1!05/27/2008-09:45:39:: Call to GetPermissionsAction(/ATM monitoring/Динамика).
w3wp!library!5!05/27/2008-09:45:39:: Call to GetReportParametersAction(/ATM monitoring/Динамика).
w3wp!library!1!05/27/2008-09:45:39:: Call to GetSystemPropertiesAction().
w3wp!library!8!05/27/2008-09:45:58:: Call to GetPropertiesAction(/ATM monitoring/Динамика, PathBased).
w3wp!library!8!05/27/2008-09:45:58:: Call to GetSystemPermissionsAction().
w3wp!library!8!05/27/2008-09:45:58:: Call to GetPermissionsAction(/ATM monitoring/Динамика).
w3wp!library!8!05/27/2008-09:45:58:: Call to GetReportParametersAction(/ATM monitoring/Динамика).
w3wp!library!8!05/27/2008-09:45:58:: Call to GetSystemPropertiesAction().
w3wp!library!8!05/27/2008-09:46:01:: Call to GetPropertiesAction(/ATM monitoring/Динамика, PathBased).
w3wp!library!8!05/27/2008-09:46:01:: Call to GetSystemPermissionsAction().
w3wp!library!8!05/27/2008-09:46:01:: Call to GetPermissionsAction(/ATM monitoring/Динамика).
w3wp!library!8!05/27/2008-09:46:01:: Call to GetReportParametersAction(/ATM monitoring/Динамика).
w3wp!library!8!05/27/2008-09:46:01:: Call to GetReportParametersAction(/ATM monitoring/Динамика).
w3wp!library!8!05/27/2008-09:46:02:: Call to GetSystemPropertiesAction().
w3wp!library!8!05/27/2008-09:46:03:: Call to GetPropertiesAction(/ATM monitoring/Динамика, PathBased).
w3wp!library!8!05/27/2008-09:46:03:: Call to GetSystemPermissionsAction().
w3wp!library!8!05/27/2008-09:46:03:: Call to GetPermissionsAction(/ATM monitoring/Динамика).
w3wp!library!8!05/27/2008-09:46:03:: Call to GetReportParametersAction(/ATM monitoring/Динамика).
w3wp!library!8!05/27/2008-09:46:03:: Call to GetReportParametersAction(/ATM monitoring/Динамика).
w3wp!library!8!05/27/2008-09:46:04:: Call to GetSystemPropertiesAction().
w3wp!library!5!05/27/2008-09:46:12:: Call to GetPropertiesAction(/ATM monitoring/Динамика, PathBased).
w3wp!library!5!05/27/2008-09:46:12:: Call to GetSystemPermissionsAction().
w3wp!library!5!05/27/2008-09:46:12:: Call to GetPermissionsAction(/ATM monitoring/Динамика).
w3wp!library!5!05/27/2008-09:46:12:: Call to GetReportParametersAction(/ATM monitoring/Динамика).
w3wp!library!5!05/27/2008-09:46:13:: Call to CreateSubscriptionAction().
w3wp!library!5!05/27/2008-09:46:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Произошла внутренняя ошибка на сервере отчетов. Дополнительные подробности см. в журнале ошибок., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Произошла внутренняя ошибка на сервере отчетов. Дополнительные подробности см. в журнале ошибок. ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'sp_add_category', database 'msdb', schema 'dbo'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.CreateCategoryID()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.get_CategoryID()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.CreateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.CreateTimeBasedSubscriptionSchedule(String reportName, Guid subscriptionID, Task task)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData, UserContext userContext)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.CreateSubscription(Guid id, String report, Guid reportID, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings, Byte[] reportSecDesc)
at Microsoft.ReportingServices.Library.CreateSubscriptionAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
--- End of inner exception stack trace ---
w3wp!library!5!05/27/2008-09:46:13:: Call to GetSystemPropertiesAction().



Подскажите, что тут можно сделать!

Помогло тут http://www.sql.ru/forum/actualthread.aspx?tid=512365