Schedule and Delivery Processor errors

Hi all,

We're running into some random errors on our reporting server (Windows Server 2003, SQL Server 2000 Enterprise). In the application logs, we're seeing several Schedule and Delivery Processor errors (ID 108)...one for each processing extension (FileShare, Excel, HTML, etc.). In the security logs, at the same time of day, are several failure audits with the following info:

EventID: 680
User: NT AUTHORITY\SYSTEM
Description: Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0. Logon account: sqluser.

The odd thing is that the schedules that are failing run perfectly about 98% of the time. Once every few weeks we have a situation like this and all of our reports (approximately 200 of them...mostly Excel, all of them sent via E-Mail) fail.

Any ideas as to what might be causing this, and why it would only happen occasionally? Any help would be appreciated! Thanks!

-Brian
http://searchwindowssecurity.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid45_gci1007131_tax299886,00.html?bucket=ETA&topic=299886|||Thanks Greg, however this link seems to relate to making sure the ASP.NET account has the appropriate permissions on both the web server and the database. In my situation, the account (sqluser) has the correct permissions for the database. The database and report server/IIS are both on the same box if that matters.

In fact, and this is what is really confusing me, everything works just fine for weeks on end...then without warning I start getting these errors and the jobs fail. Same account, same reports, same schedules, same recipients...nothing has changed, yet something has caused these errors. Any other thoughts?
|||

Do you think it could be a DOS attack?

Is it happening the same day of the week? Same time of day?

How many "accounts" are accessing the server? Some versions of SQL have a max amount of connections before it denies access.

Schedule and Delivery Processor Error

I am having issues with getting our Development Report Services Server to
schedule any reports to run. Recently, I had to change our service account
to a non-expiring one and now I get the following in our Event Log.
Schedule and Delivery Processor
Failed to decrypt symmetric key. Most likely cause is the serivce username
has changed.
Our setup is as follows:
W2K3 Web Server (running Reporting Services) and a seperate SQL 2000
Enterprise Server housing the Reporting Services database. I have run the
rsconfig and the rsactivate after changing the service account which
completed successfully.
Does anyone have any suggestions, short of totally reinstalling, to get this
error corrected and the scheduler working?
Thanks,
Greg QuinnI answered my own question. By running the rskeymgmt utility with the -d
flag I was able to delete all encrypted information from the reporting
services database and then ran the rsactivate and then reapplied the
datasources, parameters and schedules. Now everything appears to be working
correctly.
"Gregory C. Quinn, Jr." <gquinn@.yadtel.net> wrote in message
news:11vpjatmrfu45d2@.corp.supernews.com...
>I am having issues with getting our Development Report Services Server to
>schedule any reports to run. Recently, I had to change our service account
>to a non-expiring one and now I get the following in our Event Log.
> Schedule and Delivery Processor
> Failed to decrypt symmetric key. Most likely cause is the serivce username
> has changed.
> Our setup is as follows:
> W2K3 Web Server (running Reporting Services) and a seperate SQL 2000
> Enterprise Server housing the Reporting Services database. I have run the
> rsconfig and the rsactivate after changing the service account which
> completed successfully.
> Does anyone have any suggestions, short of totally reinstalling, to get
> this error corrected and the scheduler working?
> Thanks,
> Greg Quinn
>

Schedule and Delivery processor cannot connect

Hello,
I'm getting the following error on the application log of the event viewer:
Schedule and Delivery processor cannot connect to the report server database.
However I have no trouble to test some reports (e.g. the sample reports provided with reporting services).
What could be wrong with my configuration?
Thanks
CesarCan you look in the reportserverservice<date>.log files for more
information.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cesar" <Cesar@.discussions.microsoft.com> wrote in message
news:BAF05421-386E-4712-8503-A304A1626C24@.microsoft.com...
> Hello,
> I'm getting the following error on the application log of the event
viewer:
> Schedule and Delivery processor cannot connect to the report server
database.
> However I have no trouble to test some reports (e.g. the sample reports
provided with reporting services).
> What could be wrong with my configuration?
> Thanks
> Cesar|||Hello daniel,
On one line of the log says:
"Cannot open database requested in login 'Report Server'. Login fails"
How can I fix that ?
But I had no errors during set up when I configured the account with which reporting services would use to connect to the database.
"Daniel Reib [MSFT]" wrote:
> Can you look in the reportserverservice<date>.log files for more
> information.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Cesar" <Cesar@.discussions.microsoft.com> wrote in message
> news:BAF05421-386E-4712-8503-A304A1626C24@.microsoft.com...
> > Hello,
> >
> > I'm getting the following error on the application log of the event
> viewer:
> >
> > Schedule and Delivery processor cannot connect to the report server
> database.
> >
> > However I have no trouble to test some reports (e.g. the sample reports
> provided with reporting services).
> >
> > What could be wrong with my configuration?
> > Thanks
> > Cesar
>
>