Getting Error when create File Share or Email Subscription

  • I have just deployed a new project on the server and i can successfully run report from the BI Site; [Server Name]\Reports and no issue there. But when i try to create Subscription for the same report; I am trying File Share and it throws error as given below. Do i have to configure anything for subscription in the Reporting Services Configuration Tool???

    I also have few questions regarding Configuration;

    What account should i use for the Deployed Data Source on the Server? A valid SQL Server Account I assume!!!

    What account should i use for the Execution Account (For Unattended Operations) ? A valid Windows Account? or SQL Server account?

    What account should i use for the File Share Subscription (Credentials used to access the file share:)? A Valid Windows Account with permission for that folder?

    Here is the error I am getting in the log file..

    ReportingServicesService!library!b!06/17/2010-09:35:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., AuthzInitializeContextFromSid: Win32 error: 110;

    Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.

    ReportingServicesService!library!b!06/17/2010-09:35:04:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.

    ReportingServicesService!subscription!b!06/17/2010-09:35:04:: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The report server has encountered a configuration error. See the report server log files for more information. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.

    at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)

    at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)

    at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)

    at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)

    at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)

    at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)

    at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)

    at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)

    at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)

    at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()

    at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()

    --- End of inner exception stack trace ---

    at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()

    at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)

    at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo)

    at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData data)

    at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Deliver(Notification notification)

    I also get following error when I try to create email Subscriptoin

    w3wp!processing!6!6/17/2010-09:58:53:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'EU_Database'., ;

    Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'EU_Database'. ---> System.Data.SqlClient.SqlException: Could not obtain information about Windows NT group/user 'THRY\RPUser', error code 0x6e.

    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.RunExecuteNonQueryTds(String methodName, Boolean async)

    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

    at Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper.ImpersonateUser()

    at Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper.Open()

    at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc)

    --- End of inner exception stack trace ---

    Thanks,

    RP

    -RP

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply