Embedded Code: whats the trick?

OK, I give up -- I can't get this to work. I am trying to put the following function into my report (RS 2005):

Public Shared Function ReportTotal(ByVal IsUnitCost As Boolean,ByVal TotalDirectCosts As Double, ByVal SalaryBenefitsTotal As Double, ByVal IndirectRate As Double, ByVal SS_Screened As Integer, ByVal UnitRate As Double) As Double
If IsUnitCost Then
Return SS_Screened * UnitRate
Else
Return TotalDirectCosts + SalaryBenefitsTotal * IndirectRate
End If
End Function

Supposedly, to use this code you put something like this for the expression in one of your fields: =Code.ReportTotal(...paramaters...)

However, when I type in "Code.", "ReportTotal" is not in the list provided by the Intellisense. If I type it in anyway, there is a red squiggly line under "ReportTotal", and then if I try to preview the report, I get an error: "The definition of report [report name] is invalid. Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' is thrown".

Real helpful. Does this mean there's an error in the Visual Basic? I tried to access the function improperly? What?

I tried with and without "Public", with and without "Shared". Same result.

Can anyone help??

I'm not familiar yet with 2005, but in 2000, there is a tab in the 'Report Properties' dialogue under the 'Report' menu.

If you put the code in there, IE:

Function FormatDateInterval(ByVal value As DateTime) As String
Return Year(value) & "-" & Month(value)
End Function

You can call the function by using something like:

= Code.FormatDateInterval(First(Fields!SaleDate.Value, "Foreclosures"))

Like I said, it works well in 2000. Hope it helps.

|||

Actually I found the answer. My code was fine -- it just doesn't get compiled until you deploy the report. I was testing it out in "preview" mode, and that's why it wasn't working.

Needless to say, this little feature is not documented anywhere!

sql

Embedded code didnt work

In the code tab of Report Properties window, I pasted the following VB code:

Public Function Divide(Numerator As Double, Denominator As Double)
If Denominator = 0 Then
Return 0
Else
Return Numerator/Denominator
End If
End Function

But when I tried to reference the above function using "Code." in my expression, I saw an "Unrecognized Identifier" when I put my mouse onto this function in the expression edit window. Why? What I did is just copy the above function to the code tab and then start to reference it in the expression, what did I missed? Thanks for your opinion.

Change your function to:

Function Divide(Numerator As Double, Denominator As Double) As Double
If Denominator = 0 Then
Return 0
Else
Return Numerator/Denominator
End If
End Function

When you call it, use:

Code.Divide(10, 5)

Email Task

In my DTS package I tried to make an email task and it works if I execute it manualy, but if I schedule it I get the following error:

DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_16 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_16 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 8 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 8 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSSendMailTask_1 DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147220352 (80040480); Provider Error: 0 (0) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Erro... Process Exit Code 1. The step failed.

What could it be?SQLAgent service account should be used to set up the mail profile.|||Got that to work, Thanks,

But now I am getting into another error:
Executed as user: UPSAPP\SQLService. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_16 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_16 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun: Package execution complete. Process Exit Code 1. The step failed.

This is happends when I am exporting a table into .xls file on the network drive.
Any ideas? Why is it using Microsoft JET Database Engine from SQL Server? Why can't it create a file, and why is it creating a file, i already have the file there.

Thanks in advance.|||So, if you're trying to append to the file, you just say so in your task desgn. The reason you're getting the error is because upon an attempt to append to the file it looks for it, and it can't find it because this account (SQLAgent service account) doesn't have permission to even read that share. So, it tries to create one (by design), and failes due to the same permission issue.|||So how would I tell the network admin to add that account for permission to that drive?|||First, confirm that permission is the issue by logging in with SQLAgent service account to demonstrate to yourself and then to your network admin that this is the case.|||And remember, when you execute a DTS package, it runs using your account. When you schedule it as a job, it runs as SQLAgent. This can confuse things when you are trying to debug permissions.

Email Subscriptions

I have my email set up and it works fine when I email the link, however when
I try to include the report in the email I get the following error message.
Failure sending mail: An internal error occurred on the report server. See
the error log for more details. Is this a set up issue?
Thanks.Not necessarily. Can you post the log file. At least the relevant part.
The log file is called ReportServerService<timestamp>.log
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"nscotia17" <nscotia17@.discussions.microsoft.com> wrote in message
news:81B6C46C-CD66-4721-9BB1-6454D9C4F85D@.microsoft.com...
>I have my email set up and it works fine when I email the link, however
>when
> I try to include the report in the email I get the following error
> message.
> Failure sending mail: An internal error occurred on the report server. See
> the error log for more details. Is this a set up issue?
> Thanks.|||Here is the log file when trying to email an attached report through
subscriptions.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Mountain Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__03_07_2005_15_19_09.log</Path>
<SystemName>NAVSUAPP702</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!1c48!3/7/2005-15:19:10:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!1c48!3/7/2005-15:19:10:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 38449 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO: Memory
stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Initializing
crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Exporting
public key
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Performing
sku validation
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10:: EventPolling
polling service started
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10::
NotificationPolling polling service started
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!c20!3/7/2005-15:19:10:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!1e9c!3/7/2005-15:19:10::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:19:10:: Polling started
ReportingServicesService!library!1c48!3/7/2005-15:29:10:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 1
chunks, 0 running jobs
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:30:05:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05:: EventPolling
processing item 9872c0b5-f8dc-4387-97dd-d206e5819124
ReportingServicesService!library!1c48!3/7/2005-15:30:05:: Schedule
dceba956-d832-453e-b603-b735093c283e executed at 3/7/2005 3:30:05 PM.
ReportingServicesService!schedule!1c48!3/7/2005-15:30:05:: Creating Time
based subscription notification for subscription:
5acf26d9-5330-466d-8b5d-32a563bd8c51
ReportingServicesService!library!1c48!3/7/2005-15:30:05:: Schedule
dceba956-d832-453e-b603-b735093c283e execution completed at 3/7/2005 3:30:05
PM.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05:: EventPolling
finished processing item 9872c0b5-f8dc-4387-97dd-d206e5819124
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:30:05::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05::
NotificationPolling processing item f391b132-a040-4f87-ab13-f53ffe36096a
ReportingServicesService!library!1c48!03/07/2005-15:30:05:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: i INFO: Call to
RenderFirst( '/PMAC Test/Net SalesC6' )
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.InvalidOperationException: The key 'RsDbPassword' does
not exist in the appSettings configuration section.
at System.Configuration.AppSettingsReader.GetValue(String key, Type type)
at Navitaire.dotRez.Reporting.Extensions.Security.Utils.getAppSettings()
at
Navitaire.dotRez.Reporting.Extensions.Security.Utils.GetConfigurationInfo(String settingName)
at
Navitaire.dotRez.Reporting.Extensions.Security.Authorization.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&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(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)
-- End of inner exception stack trace --
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1c48!03/07/2005-15:30:06:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
An internal error occurred on the report server. See the error log for more
details. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.InvalidOperationException: The key 'RsDbPassword' does
not exist in the appSettings configuration section.
at System.Configuration.AppSettingsReader.GetValue(String key, Type type)
at Navitaire.dotRez.Reporting.Extensions.Security.Utils.getAppSettings()
at
Navitaire.dotRez.Reporting.Extensions.Security.Utils.GetConfigurationInfo(String settingName)
at
Navitaire.dotRez.Reporting.Extensions.Security.Authorization.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&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(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)
-- End of inner exception stack trace --
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, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!1c48!03/07/2005-15:30:06::
Notification f391b132-a040-4f87-ab13-f53ffe36096a completed. Success: False,
Status: Failure sending mail: An internal error occurred on the report
server. See the error log for more details., DeliveryExtension: Report Server
Email, Report: Net SalesC6, Attempt 0
ReportingServicesService!dbpolling!1c48!03/07/2005-15:30:06::
NotificationPolling finished processing item
f391b132-a040-4f87-ab13-f53ffe36096a
ReportingServicesService!library!1c48!03/07/2005-15:39:10:: Using folder
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
for temporary files.
ReportingServicesService!library!1c48!03/07/2005-15:39:10:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 6
chunks, 0 running jobs
Thanks.
"Daniel Reib [MSFT]" wrote:
> Not necessarily. Can you post the log file. At least the relevant part.
> The log file is called ReportServerService<timestamp>.log
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "nscotia17" <nscotia17@.discussions.microsoft.com> wrote in message
> news:81B6C46C-CD66-4721-9BB1-6454D9C4F85D@.microsoft.com...
> >I have my email set up and it works fine when I email the link, however
> >when
> > I try to include the report in the email I get the following error
> > message.
> > Failure sending mail: An internal error occurred on the report server. See
> > the error log for more details. Is this a set up issue?
> > Thanks.
>
>

email subscription to hotmail?

Hello...

I have a Virtual PC running SSRS 2005. I keep getting the following error when I try to specify my hotmail account as the To line in the email subscription:

"The e-mail address of one or more recipients is not valid."

I am trying to set it up such that I can send email subscriptions to my hotmail account, or at least let the SMTP Service accept these emails. I don't necesarily need to have these emails delivered, but I would like them to at least be accepted by the SMTP Service. I have added the following to my rsreportserver.config file:

<PermittedHosts>
<HostName>hotmail.com</HostName>
</PermittedHosts>

I am sure I need to configure the IIS SMTP Server settings somehow, does anyone know how to configure my local SMTP Service to allow @.hotmail.com email addresses to be placed into the "Drop" folder?

TIA

All,

After reading through some more posts online (searching through Google groups, yes Google groups MS folks!!!) I found what I needed to do. In fact, what I found does a lot more than I needed to do, it actually sends the email to the external account.

This is NOT a Reporting Services configuration issue. This is an SMTP Service configuration issue (as I suspected). Here is what I did. This may or may not be the "correct" way to do things, but it certainly works for my test environment (Note that this configuration probably shouldn't be used in a production enviornment!!!):

1. Open IIS Manager and right-click the "Default SMTP Virtual Server" and select "Properties".

2. On the Properties dialog, select the Access tab.

3. From the Access tab, click the "Relay..." button (near the bottom of the tab).

4. From the Relay Restrictions dialog, select the "All except the list below" option. Ensure that the "Allow all computers which successfully authenticate to relay, regardless of the list above" checkbox is checked.

5. Click OK on the Relay Restrictions dialog.

6. Click OK on the "Default SMTP Virtual Server Properties" dialog.

7. Stop, then Start the SMTP Service.

8. Setup your email subscription with your external email account and let it run.

Again, this worked for my development\test environment, but you should probably investigate further if you want to use this in a production environment as I am sure that setting up your SMTP Service for relay in this way probably opens it up to all sorts of attacks (like SPAM).

Hope that this helps others experiencing the same/similar issue!!

|||

Also:

9. I got rid of the items I added to the PermittedHosts element, this way I am not restricted to which domains I sent to. Obviously in a production enviornment you would not want to do this.

Email Subscription Problem

I have an install of Reporting Services which when trying to send an email based subscription, returns the following error;

Failure sending mail: Retrieving the COM class factory for component with CLSID {CD000001-8B95-11D1-82DB-00C04FB1625D} failed due to the following error: 80040154.

No errors are shown in the RS logs or the events logs.

Does anybody have any ideas what could be causing this?

I don't know what version you are using but when it first came out it was hard for most people to install it but I did not get a hard time because I ignored all Windows questions. So I remember it asking for Exchange server you will use with it, if you did not configure Exchange, SMTP or SQL Server Agent to use for your mail that could be the reason for the error. Hope this helps.|||Thanks for your reply. I've double-checked all the configuration and everything appears fine. :(sql

Email subscription error on credentials

Hello,

When trying to subscribe to an report via email I get to following error

The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)

Can anybody help me with this issue.

Greetings

Vinnie

The username and password need to be stored on the server.

The report is trying to connect to the db with the datasource, but you have not supplied any credentials.

In the data source properties, enter the username and password you wish the RS to connect to the db with.|||

hi,

thanks for the quick response.

I get what you mean, but why does the reportserver does not ask for those credentials when i generate the report

with the reportviewer, but only for a subscription?

Does this mean that i have to specify username and password in my datasource for my reports (in the credentials tab)

Greetings

Vinnie

|||When you are running the report through reportviewer, it already has your credentials.
When it is running as a subscription, it is essentially running 'unattended' so it cannot validate whether it can connect to the db.

By embedding your credentials, it can check if it has permissions to run the report, just as if you were logged on to your machine and trying to run it through IE/report viewer

Email subscription Configuration

Hi,
In configuring the the email extensions for the email subscriptions, we have
done the following: Applied SP1
Configured the email extension section of the RSreportingservices.config for
the FQDN of the exchange server.
Emails are not being sent. Error indicates configuration problem. What are
we missing here?
Thanks and please ignore the previous posting. this is the same one.Can you post the error from the log file? If you are able to create
subscriptions then the config file is correct and the issue is usually a
permission issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Seth" <Seth@.discussions.microsoft.com> wrote in message
news:BD436AA1-2C27-4997-A84D-3EA08B32489E@.microsoft.com...
> Hi,
> In configuring the the email extensions for the email subscriptions, we
have
> done the following: Applied SP1
> Configured the email extension section of the RSreportingservices.config
for
> the FQDN of the exchange server.
> Emails are not being sent. Error indicates configuration problem. What are
> we missing here?
> Thanks and please ignore the previous posting. this is the same one.
>|||Hi Daniel, Thanks for getting back to me. Which log file do you need to see?
You are right in that I am able to create the subscription.
Thanks
Seth
"Daniel Reib [MSFT]" wrote:
> Can you post the error from the log file? If you are able to create
> subscriptions then the config file is correct and the issue is usually a
> permission issue.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Seth" <Seth@.discussions.microsoft.com> wrote in message
> news:BD436AA1-2C27-4997-A84D-3EA08B32489E@.microsoft.com...
> > Hi,
> > In configuring the the email extensions for the email subscriptions, we
> have
> > done the following: Applied SP1
> > Configured the email extension section of the RSreportingservices.config
> for
> > the FQDN of the exchange server.
> >
> > Emails are not being sent. Error indicates configuration problem. What are
> > we missing here?
> >
> > Thanks and please ignore the previous posting. this is the same one.
> >
> >
>
>|||ReportServerService<date>.log
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Seth" <Seth@.discussions.microsoft.com> wrote in message
news:EE1C1FFB-EEC3-4570-8FF0-C8C7CA18BC0F@.microsoft.com...
> Hi Daniel, Thanks for getting back to me. Which log file do you need to
see?
> You are right in that I am able to create the subscription.
> Thanks
> Seth
> "Daniel Reib [MSFT]" wrote:
> > Can you post the error from the log file? If you are able to create
> > subscriptions then the config file is correct and the issue is usually a
> > permission issue.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Seth" <Seth@.discussions.microsoft.com> wrote in message
> > news:BD436AA1-2C27-4997-A84D-3EA08B32489E@.microsoft.com...
> > > Hi,
> > > In configuring the the email extensions for the email subscriptions,
we
> > have
> > > done the following: Applied SP1
> > > Configured the email extension section of the
RSreportingservices.config
> > for
> > > the FQDN of the exchange server.
> > >
> > > Emails are not being sent. Error indicates configuration problem. What
are
> > > we missing here?
> > >
> > > Thanks and please ignore the previous posting. this is the same one.
> > >
> > >
> >
> >
> >|||Hi,
Just was wondering which log file I should pull to post and review the email
configuration permissions issue.
Thanks
Seth
"Daniel Reib [MSFT]" wrote:
> ReportServerService<date>.log
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Seth" <Seth@.discussions.microsoft.com> wrote in message
> news:EE1C1FFB-EEC3-4570-8FF0-C8C7CA18BC0F@.microsoft.com...
> > Hi Daniel, Thanks for getting back to me. Which log file do you need to
> see?
> > You are right in that I am able to create the subscription.
> >
> > Thanks
> > Seth
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > Can you post the error from the log file? If you are able to create
> > > subscriptions then the config file is correct and the issue is usually a
> > > permission issue.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Seth" <Seth@.discussions.microsoft.com> wrote in message
> > > news:BD436AA1-2C27-4997-A84D-3EA08B32489E@.microsoft.com...
> > > > Hi,
> > > > In configuring the the email extensions for the email subscriptions,
> we
> > > have
> > > > done the following: Applied SP1
> > > > Configured the email extension section of the
> RSreportingservices.config
> > > for
> > > > the FQDN of the exchange server.
> > > >
> > > > Emails are not being sent. Error indicates configuration problem. What
> are
> > > > we missing here?
> > > >
> > > > Thanks and please ignore the previous posting. this is the same one.
> > > >
> > > >
> > >
> > >
> > >
>
>|||I wrote the log file name below:
ReportServerService<date>.log file.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Seth" <Seth@.discussions.microsoft.com> wrote in message
news:4B047C0A-8A75-4AAC-BF75-7EEF70C951C3@.microsoft.com...
> Hi,
> Just was wondering which log file I should pull to post and review the
email
> configuration permissions issue.
> Thanks
> Seth
>
> "Daniel Reib [MSFT]" wrote:
> > ReportServerService<date>.log
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Seth" <Seth@.discussions.microsoft.com> wrote in message
> > news:EE1C1FFB-EEC3-4570-8FF0-C8C7CA18BC0F@.microsoft.com...
> > > Hi Daniel, Thanks for getting back to me. Which log file do you need
to
> > see?
> > > You are right in that I am able to create the subscription.
> > >
> > > Thanks
> > > Seth
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > Can you post the error from the log file? If you are able to create
> > > > subscriptions then the config file is correct and the issue is
usually a
> > > > permission issue.
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Seth" <Seth@.discussions.microsoft.com> wrote in message
> > > > news:BD436AA1-2C27-4997-A84D-3EA08B32489E@.microsoft.com...
> > > > > Hi,
> > > > > In configuring the the email extensions for the email
subscriptions,
> > we
> > > > have
> > > > > done the following: Applied SP1
> > > > > Configured the email extension section of the
> > RSreportingservices.config
> > > > for
> > > > > the FQDN of the exchange server.
> > > > >
> > > > > Emails are not being sent. Error indicates configuration problem.
What
> > are
> > > > > we missing here?
> > > > >
> > > > > Thanks and please ignore the previous posting. this is the same
one.
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Hi,
I've copied in the log file. It appears the Service account does not have
rights to check Domain User SIDs. What are the minimum rights that need to be
assigned to the service account to enable this check?
Thanks
Seth
ReportingServicesService!library!1010!09/20/2004-10:20:17:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!124c!09/20/2004-10:20:17:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!124c!09/20/2004-10:20:17:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!library!1010!09/20/2004-10:20:17:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1010!09/20/2004-10:20:17:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
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&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(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, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!emailextension!124c!09/20/2004-10:20:17:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
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&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(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, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!1010!09/20/2004-10:20:17::
Notification 86ea118c-426e-4437-88f0-003334bb55d5 completed. Success: False,
Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension: Report
Server Email, Report: Daily Sales Report, Attempt 0
ReportingServicesService!notification!124c!09/20/2004-10:20:17::
Notification f1efc495-fbde-472c-b2d4-2d10d764a8ce completed. Success: False,
Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension: Report
Server Email, Report: Daily Sales Report, Attempt 0
ReportingServicesService!dbpolling!1010!09/20/2004-10:20:17::
NotificationPolling finished processing item
86ea118c-426e-4437-88f0-003334bb55d5
ReportingServicesService!dbpolling!124c!09/20/2004-10:20:18::
NotificationPolling finished processing item
f1efc495-fbde-472c-b2d4-2d10d764a8ce
ReportingServicesService!library!1010!09/20/2004-10:29:20:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
chunks, 0 running jobs
ReportingServicesService!dbpolling!13ec!9/20/2004-10:30:08:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1010!09/20/2004-10:30:08:: EventPolling
processing item 35f3bce5-4b03-4783-982a-eef1f24c6e79
ReportingServicesService!library!1010!09/20/2004-10:30:08:: Schedule
f09df173-b1f4-4508-8731-0ffc0a242d70 executed at 09/20/2004 10:30:08.
ReportingServicesService!schedule!1010!09/20/2004-10:30:08:: Creating Time
based subscription notification for subscription:
22e2072c-0aff-4a90-a7de-43113bec8cff
ReportingServicesService!library!1010!09/20/2004-10:30:08:: Schedule
f09df173-b1f4-4508-8731-0ffc0a242d70 execution completed at 09/20/2004
10:30:08.
ReportingServicesService!dbpolling!1010!09/20/2004-10:30:09:: EventPolling
finished processing item 35f3bce5-4b03-4783-982a-eef1f24c6e79
ReportingServicesService!dbpolling!13ec!9/20/2004-10:30:09::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!124c!09/20/2004-10:30:09::
NotificationPolling processing item 9ba66041-5803-4486-8b67-f2f8d2fed99b
ReportingServicesService!library!124c!09/20/2004-10:30:09:: i INFO: Call to
RenderFirst( '/GMB/Brand Depletions By State' )
ReportingServicesService!library!124c!09/20/2004-10:30:09:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!124c!09/20/2004-10:30:09:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!124c!09/20/2004-10:30:09:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
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&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(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, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!124c!09/20/2004-10:30:09::
Notification 9ba66041-5803-4486-8b67-f2f8d2fed99b completed. Success: False,
Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension: Report
Server Email, Report: Brand Depletions By State, Attempt 0
ReportingServicesService!dbpolling!124c!09/20/2004-10:30:09::
NotificationPolling finished processing item
9ba66041-5803-4486-8b67-f2f8d2fed99b
ReportingServicesService!library!124c!09/20/2004-10:39:20:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-10:49:20:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-10:59:20:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-11:09:20:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-11:19:20:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-11:29:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-11:39:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-11:49:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-11:59:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-12:09:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-12:19:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-12:29:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-12:39:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-12:49:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-12:59:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-13:09:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-13:19:19:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 8 snapshots, 16
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-13:29:18:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 8
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-13:39:18:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-13:49:18:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-13:59:18:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-14:09:18:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-14:19:18:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-14:29:18:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-14:39:18:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-14:49:18:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-14:59:17:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-15:09:17:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-15:19:17:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-15:29:17:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-15:39:17:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-15:49:17:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-15:59:17:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-16:09:17:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-16:19:17:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-16:29:17:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-16:39:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-16:49:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-16:59:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-17:09:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-17:19:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-17:29:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-17:39:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-17:49:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-17:59:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-18:09:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-18:19:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-18:29:16:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-18:39:15:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-18:49:15:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-18:59:15:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-19:09:15:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-19:19:15:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-19:29:15:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-19:39:15:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-19:49:15:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-19:59:15:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-20:09:15:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-20:19:14:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-20:29:14:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-20:39:14:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-20:49:14:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-20:59:14:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-21:09:14:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-21:19:14:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-21:29:14:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-21:39:14:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!124c!09/20/2004-21:49:14:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!dbpolling!1204!9/20/2004-21:49:21:: EventPolling
polling service stopped
ReportingServicesService!dbpolling!25c!9/20/2004-21:49:21:: EventPolling
heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!1204!9/20/2004-21:49:21::
NotificationPolling polling service stopped
ReportingServicesService!dbpolling!1180!9/20/2004-21:49:21::
NotificationPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!1204!9/20/2004-21:49:21:: SchedulePolling
polling service stopped
ReportingServicesService!servicecontroller!1204!9/20/2004-21:49:22:: Service
controller exiting.
"Daniel Reib [MSFT]" wrote:
> I wrote the log file name below:
> ReportServerService<date>.log file.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Seth" <Seth@.discussions.microsoft.com> wrote in message
> news:4B047C0A-8A75-4AAC-BF75-7EEF70C951C3@.microsoft.com...
> > Hi,
> > Just was wondering which log file I should pull to post and review the
> email
> > configuration permissions issue.
> >
> > Thanks
> > Seth
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > ReportServerService<date>.log
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Seth" <Seth@.discussions.microsoft.com> wrote in message
> > > news:EE1C1FFB-EEC3-4570-8FF0-C8C7CA18BC0F@.microsoft.com...
> > > > Hi Daniel, Thanks for getting back to me. Which log file do you need
> to
> > > see?
> > > > You are right in that I am able to create the subscription.
> > > >
> > > > Thanks
> > > > Seth
> > > >
> > > > "Daniel Reib [MSFT]" wrote:
> > > >
> > > > > Can you post the error from the log file? If you are able to create
> > > > > subscriptions then the config file is correct and the issue is
> usually a
> > > > > permission issue.
> > > > >
> > > > > --
> > > > > -Daniel
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > >
> > > > > "Seth" <Seth@.discussions.microsoft.com> wrote in message
> > > > > news:BD436AA1-2C27-4997-A84D-3EA08B32489E@.microsoft.com...
> > > > > > Hi,
> > > > > > In configuring the the email extensions for the email
> subscriptions,
> > > we
> > > > > have
> > > > > > done the following: Applied SP1
> > > > > > Configured the email extension section of the
> > > RSreportingservices.config
> > > > > for
> > > > > > the FQDN of the exchange server.
> > > > > >
> > > > > > Emails are not being sent. Error indicates configuration problem.
> What
> > > are
> > > > > > we missing here?
> > > > > >
> > > > > > Thanks and please ignore the previous posting. this is the same
> one.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||Take a look at the following article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/secauthz/security/authzinitializecontextfromsid.asp
There is a paragraph at the bottom which starts with "Important" which
describes the permissions necessary.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Seth" <Seth@.discussions.microsoft.com> wrote in message
news:70DDB3C1-584D-4C67-B934-FFB45DCF189A@.microsoft.com...
> Hi,
> I've copied in the log file. It appears the Service account does not have
> rights to check Domain User SIDs. What are the minimum rights that need to
be
> assigned to the service account to enable this check?
> Thanks
> Seth
>
> ReportingServicesService!library!1010!09/20/2004-10:20:17:: e ERROR:
> Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files, AuthzInitializeContextFromSid: Win32 error: 5; possible
reason -
> service account doesn't have rights to check domain user SIDs.;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> ReportingServicesService!library!124c!09/20/2004-10:20:17:: e ERROR:
> Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files, AuthzInitializeContextFromSid: Win32 error: 5; possible
reason -
> service account doesn't have rights to check domain user SIDs.;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> ReportingServicesService!library!124c!09/20/2004-10:20:17:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
system
> properties.
> ReportingServicesService!library!1010!09/20/2004-10:20:17:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
system
> properties.
> ReportingServicesService!emailextension!1010!09/20/2004-10:20:17:: Error
> sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> The Report Server has encountered a configuration error; more details in
the
> log files -->
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> at
>
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g
> userName, IntPtr userToken)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
>
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
values,
> DatasourceCredentialsCollection credentials)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext
> 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(RS
Service
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
> ReportingServicesService!emailextension!124c!09/20/2004-10:20:17:: Error
> sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> The Report Server has encountered a configuration error; more details in
the
> log files -->
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> at
>
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g
> userName, IntPtr userToken)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
>
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
values,
> DatasourceCredentialsCollection credentials)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext
> 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(RS
Service
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
> ReportingServicesService!notification!1010!09/20/2004-10:20:17::
> Notification 86ea118c-426e-4437-88f0-003334bb55d5 completed. Success:
False,
> Status: Failure sending mail: The Report Server has encountered a
> configuration error; more details in the log files, DeliveryExtension:
Report
> Server Email, Report: Daily Sales Report, Attempt 0
> ReportingServicesService!notification!124c!09/20/2004-10:20:17::
> Notification f1efc495-fbde-472c-b2d4-2d10d764a8ce completed. Success:
False,
> Status: Failure sending mail: The Report Server has encountered a
> configuration error; more details in the log files, DeliveryExtension:
Report
> Server Email, Report: Daily Sales Report, Attempt 0
> ReportingServicesService!dbpolling!1010!09/20/2004-10:20:17::
> NotificationPolling finished processing item
> 86ea118c-426e-4437-88f0-003334bb55d5
> ReportingServicesService!dbpolling!124c!09/20/2004-10:20:18::
> NotificationPolling finished processing item
> f1efc495-fbde-472c-b2d4-2d10d764a8ce
> ReportingServicesService!library!1010!09/20/2004-10:29:20:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
> chunks, 0 running jobs
> ReportingServicesService!dbpolling!13ec!9/20/2004-10:30:08:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1010!09/20/2004-10:30:08:: EventPolling
> processing item 35f3bce5-4b03-4783-982a-eef1f24c6e79
> ReportingServicesService!library!1010!09/20/2004-10:30:08:: Schedule
> f09df173-b1f4-4508-8731-0ffc0a242d70 executed at 09/20/2004 10:30:08.
> ReportingServicesService!schedule!1010!09/20/2004-10:30:08:: Creating Time
> based subscription notification for subscription:
> 22e2072c-0aff-4a90-a7de-43113bec8cff
> ReportingServicesService!library!1010!09/20/2004-10:30:08:: Schedule
> f09df173-b1f4-4508-8731-0ffc0a242d70 execution completed at 09/20/2004
> 10:30:08.
> ReportingServicesService!dbpolling!1010!09/20/2004-10:30:09:: EventPolling
> finished processing item 35f3bce5-4b03-4783-982a-eef1f24c6e79
> ReportingServicesService!dbpolling!13ec!9/20/2004-10:30:09::
> NotificationPolling processing 1 more items. 1 Total items in internal
queue.
> ReportingServicesService!dbpolling!124c!09/20/2004-10:30:09::
> NotificationPolling processing item 9ba66041-5803-4486-8b67-f2f8d2fed99b
> ReportingServicesService!library!124c!09/20/2004-10:30:09:: i INFO: Call
to
> RenderFirst( '/GMB/Brand Depletions By State' )
> ReportingServicesService!library!124c!09/20/2004-10:30:09:: e ERROR:
> Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files, AuthzInitializeContextFromSid: Win32 error: 5; possible
reason -
> service account doesn't have rights to check domain user SIDs.;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> ReportingServicesService!library!124c!09/20/2004-10:30:09:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
system
> properties.
> ReportingServicesService!emailextension!124c!09/20/2004-10:30:09:: Error
> sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> The Report Server has encountered a configuration error; more details in
the
> log files -->
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> at
>
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g
> userName, IntPtr userToken)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
>
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
values,
> DatasourceCredentialsCollection credentials)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext
> 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(RS
Service
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
> ReportingServicesService!notification!124c!09/20/2004-10:30:09::
> Notification 9ba66041-5803-4486-8b67-f2f8d2fed99b completed. Success:
False,
> Status: Failure sending mail: The Report Server has encountered a
> configuration error; more details in the log files, DeliveryExtension:
Report
> Server Email, Report: Brand Depletions By State, Attempt 0
> ReportingServicesService!dbpolling!124c!09/20/2004-10:30:09::
> NotificationPolling finished processing item
> 9ba66041-5803-4486-8b67-f2f8d2fed99b
> ReportingServicesService!library!124c!09/20/2004-10:39:20:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-10:49:20:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-10:59:20:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-11:09:20:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-11:19:20:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-11:29:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-11:39:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-11:49:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-11:59:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-12:09:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-12:19:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-12:29:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-12:39:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-12:49:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-12:59:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-13:09:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-13:19:19:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 8 snapshots, 16
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-13:29:18:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 8
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-13:39:18:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-13:49:18:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-13:59:18:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-14:09:18:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-14:19:18:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-14:29:18:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-14:39:18:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-14:49:18:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-14:59:17:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-15:09:17:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-15:19:17:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-15:29:17:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-15:39:17:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-15:49:17:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-15:59:17:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-16:09:17:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-16:19:17:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-16:29:17:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-16:39:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-16:49:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-16:59:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-17:09:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-17:19:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-17:29:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-17:39:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-17:49:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-17:59:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-18:09:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-18:19:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-18:29:16:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-18:39:15:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-18:49:15:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-18:59:15:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-19:09:15:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-19:19:15:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-19:29:15:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-19:39:15:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-19:49:15:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-19:59:15:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-20:09:15:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-20:19:14:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-20:29:14:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-20:39:14:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-20:49:14:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-20:59:14:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-21:09:14:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-21:19:14:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-21:29:14:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-21:39:14:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!124c!09/20/2004-21:49:14:: i INFO:
Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!dbpolling!1204!9/20/2004-21:49:21:: EventPolling
> polling service stopped
> ReportingServicesService!dbpolling!25c!9/20/2004-21:49:21:: EventPolling
> heartbeat thread exiting for stop.
> ReportingServicesService!dbpolling!1204!9/20/2004-21:49:21::
> NotificationPolling polling service stopped
> ReportingServicesService!dbpolling!1180!9/20/2004-21:49:21::
> NotificationPolling heartbeat thread exiting for stop.
> ReportingServicesService!dbpolling!1204!9/20/2004-21:49:21::
SchedulePolling
> polling service stopped
> ReportingServicesService!servicecontroller!1204!9/20/2004-21:49:22::
Service
> controller exiting.
>
> "Daniel Reib [MSFT]" wrote:
> > I wrote the log file name below:
> >
> > ReportServerService<date>.log file.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Seth" <Seth@.discussions.microsoft.com> wrote in message
> > news:4B047C0A-8A75-4AAC-BF75-7EEF70C951C3@.microsoft.com...
> > > Hi,
> > > Just was wondering which log file I should pull to post and review the
> > email
> > > configuration permissions issue.
> > >
> > > Thanks
> > > Seth
> > >
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > ReportServerService<date>.log
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Seth" <Seth@.discussions.microsoft.com> wrote in message
> > > > news:EE1C1FFB-EEC3-4570-8FF0-C8C7CA18BC0F@.microsoft.com...
> > > > > Hi Daniel, Thanks for getting back to me. Which log file do you
need
> > to
> > > > see?
> > > > > You are right in that I am able to create the subscription.
> > > > >
> > > > > Thanks
> > > > > Seth
> > > > >
> > > > > "Daniel Reib [MSFT]" wrote:
> > > > >
> > > > > > Can you post the error from the log file? If you are able to
create
> > > > > > subscriptions then the config file is correct and the issue is
> > usually a
> > > > > > permission issue.
> > > > > >
> > > > > > --
> > > > > > -Daniel
> > > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > > >
> > > > > >
> > > > > > "Seth" <Seth@.discussions.microsoft.com> wrote in message
> > > > > > news:BD436AA1-2C27-4997-A84D-3EA08B32489E@.microsoft.com...
> > > > > > > Hi,
> > > > > > > In configuring the the email extensions for the email
> > subscriptions,
> > > > we
> > > > > > have
> > > > > > > done the following: Applied SP1
> > > > > > > Configured the email extension section of the
> > > > RSreportingservices.config
> > > > > > for
> > > > > > > the FQDN of the exchange server.
> > > > > > >
> > > > > > > Emails are not being sent. Error indicates configuration
problem.
> > What
> > > > are
> > > > > > > we missing here?
> > > > > > >
> > > > > > > Thanks and please ignore the previous posting. this is the
same
> > one.
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >sql