asked on

SSRS Event ID 108

Below are 2 errors I am getting when using SSRS 2005 that both generate an event id 108. It just started happening in the past month (we have been using SQL 2005 for 2 years now). The only thing I can think of that might have changed was the SMTP email account. Any ideas on how to fix this problem?

>>>When I try to create a new subscription in SSRS 2005 I get the following error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors

>>>When I try to delete a subscription I get the following message:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'sp_delete_job', database 'msdb', schema 'dbo'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.SubscriptionDB.DeleteSubscription(Guid id) at Microsoft.ReportingServices.Library.SubscriptionManager.DeleteSubscription(Guid id) at Microsoft.ReportingServices.Library.DeleteSubscriptionAction.PerformActionNow() at Microsoft.ReportingServices.Library.DeleteSubscriptionAction.PerformActionInBatch(CallParameters parameters) at Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ExecuteBatch() at Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch() --- End of inner exception stack trace ---

EugeneZ

what is in the error log?

check SSRS 2005 configuration
check sql server (where SSRS dbs) login permission that are you using to delete the subscription..
---
looks like - you do not have rights on sql server
"EXECUTE permission was denied on the object 'sp_delete_job', database 'msdb', schema 'dbo' "

r270ba

ASKER

I know but I cannot figure out why it would have changed all of the sudden. I am not a DBA so I may need you to clarify a little....

>>>what is in the error log?
- where is the error log?

>>> check SSRS 2005 configuration
- when I go to the SSRS Configuration on SQL everything looks ok except for an execution account...I have the warning icon

>>>check sql server (where SSRS dbs) login permission that are you using to delete the subscription..
- How do I do this?

EugeneZ

<where is the error log?

start from eventviewer
<- when I go to the SSRS Configuration on SQL everything looks ok except for an execution account...I have the warning icon
the ssrs execution account has been changed (or just lost some of permission, etc)
>>>check sql server (where SSRS dbs) login permission that are you using to delete the subscription..

login in sql server that is using SSRS- server where is SSRS ) you can check where is the sql server from SSRS Configuration
and see sql server security- add if you need - to delete\create subscription it needs at least msdb rights - ,,,

r270ba

ASKER

Ok in the error log I am getting the Event ID 108.

Do I need to do anything about the execution account having the warning or is that ok?

Again...I apologize but I am not a DBA...in management studio what exactly do I look at to add delete create to new subscription?

I am also having trouble understanding why this would have all of the sudden changed???

ASKER CERTIFIED SOLUTION

EugeneZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

r270ba

ASKER

Unfortunately I am the only IT person we have here so no one would have changed something other than me :) (I am not saying that I didn't change something on accident).

The event from the event viewer is the following:

Event Type:      Error
Event Source:      Report Server (MSSQLSERVER)
Event Category:      Extension
Event ID:      108
Date:            8/13/2008
Time:            1:28:56 PM
User:            N/A
Computer:      BOSS
Description:
Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary extension.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Here is the link to the event id info.
http://www.eventid.net/display.asp?eventid=108&eventno=6949&source=Report%20Server&phase=1

JasonDonahoe

There was a configuration issue that had changed..
What I ended up doing is restoring the ReportserverDB from a nightly backup.
restoring the encryption key and re-initializing the server.
this worked.. all the issues went away.. 10 min fix.

r270ba

ASKER

I ended up having my IT guys take a look at it. Permissions had some how been lost for the SSRS account. They restored them and everything is working now. Sorry but that is all the info that I have.