Report Server Windows Service (MSSQLSERVER)

This error is being displayed in the eventlog every minute. Any ideas on what it is referring too? I reviewed some posts but most point to specific problems of report server not running, or receiving this error during a run. We are receiving no errors at all. However this is jamming up the event viewer to make troubleshooting other issues very diffucult.

Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date: 3/23/2007
Time: 8:20:16 AM
User: N/A
Computer: SPECTRUM_DB2B
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

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

It is stating that RS can not connect to it's database. A possible reason is the way you are connecting to the RS database. In the config tool if on the Database tab it says "Service Account" then it is using whatever account the windows service is running as. It is possible someone changed this account via another tool and this account does not have rights to read the DB.

The easiest way to fix this is to go to the Database tab in the configuration tool and select "Script...". Then select "Grant Rights Script", enter the username and hit OK. After this, run the script on the SQL server. The windows service user should now be able to connect to the SQL server, making the error go away.

Report Server Windows Service (MSSQLSERVER)

I'm really stuck and I'm not sure what I'm supposed to do!?
I've started receiving the following error in my SBS2003 R2 SP2 server
performance report.
Source: Report Server Windows Service (MSSQLSERVER)
Event ID: 120
Total Occurrences: *2
The report server cannot decrypt the symmetric key. Most likely, the service
account or password has changed. To continue, run rsconfig.exe to update the
report server account information.\r\n
I'm not totally sure what commands I need to use with rsconfig.exe.
And I'm not sure if I select Delete from SQL Server 2005\Configuration
Tools\Reporting Services Configuration will cause more problems.
I've tried to Backup encryption key from Reporting Services Configuration
but it gave me the error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server
cannot decrypt the symmetric key used to access sensitive or encrypted data
in a report server database. You must either restore a backup key or delete
all encrypted content. Check the documentation for more information.
(rsReportServerDisabled)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)
which is weird becuase I've never taken a backup when I originally installed
SBS2003 R2 so I can't even Restore the encryption key.
I've tried following the threads but again I'm not totally sure.
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=cbc4ecc2-1023-4449-9838-5577a9c3b17c&sloc=en-us
Is there a way to correct this using Report Service Configuration tool or
SQL Server 2005'I hit the same issue, I dont know how. I must have installed Reporting
Services at least 6 times and 4 out of 6 times I have had wierd issues
and not the same one. ANyways..
for your problem - I just deleted the encrypted content, hit apply.
Restarted the Reporting Services and then I was able to backup the
keys fine.
On May 22, 5:57 am, ck <c...@.discussions.microsoft.com> wrote:
> I'm really stuck and I'm not sure what I'm supposed to do!?
> I've started receiving the following error in my SBS2003 R2 SP2server
> performancereport.
> Source:ReportServerWindows Service (MSSQLSERVER)
> Event ID: 120
> Total Occurrences: *2
> Thereportservercannotdecryptthesymmetrickey. Most likely, the service
> account or password has changed. To continue, run rsconfig.exe to update =thereportserveraccount information.\r\n
> I'm not totally sure what commands I need to use with rsconfig.exe.
> And I'm not sure if I selectDeletefrom SQLServer2005\Configuration
> Tools\Reporting Services Configuration will cause more problems.
> I've tried toBackupencryptionkeyfrom Reporting Services Configuration
> but it gave me the error:
> ReportServicesConfigUI.WMIProvider.WMIProviderException: Thereportserverc=annotdecryptthesymmetrickeyusedtoaccesssensitiveorencrypteddata
> in areportserverdatabase.Youmusteitherrestoreabackupkeyordeleteallencrypt=edcontent. Check the documentation for more information.
> (rsReportServerDisabled)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(Manag=em=ADentBaseObject mo)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKe=y(=ADByte[]& encryptedBytes, String password)
> which is weird becuase I've never taken abackupwhen I originally installed
> SBS2003 R2 so I can't evenRestorethe encryptionkey.
> I've tried following the threads but again I'm not totally sure.
> http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us...
> Is there a way to correct this usingReportService Configuration tool or
> SQLServer2005'

Report Server (MSSQLSERVER) cannot connect to the report server database.

I was viewing some reports, and it suddenly showed me that error, from Reporting Services Configruation I restarted the service but nothin, that s the error show on event log.

What else can I Do?

I also see this on the event log.

La configuración de permisos que depende de la aplicación no concede permiso de activación local para la aplicación de servidor COM con CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

al SID (S-1-5-20) de NT AUTHORITY\Servicio de red del usuario. Este permiso de seguridad se puede modificar mediante la herramienta administrativa Servicios de componentes.

Para obtener más información, vea el Centro de ayuda y soporte tcnico en http://go.microsoft.com/fwlink/events.asp.

|||Take a look at this previous post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=399539&SiteID=1

Report Server (MSSQLSERVER) cannot connect to the report server database

I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003 server. The configuration has been unchanged for approx. 3 weeks. Suddenly today, reports being accessed via an ASP.NET 2.0 application (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver became inaccessable. End users received the following error:

Message: An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Stack Trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at IFA.CAP.SQLReportingService.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web References\SQLReportingService\Reference.vb:line 1319
at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID, Boolean isDraft, Boolean isCertified) in C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line 551
at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e) in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287

Subsequently, the following error is logged on the Report Server/Database server:

Report Server (MSSQLSERVER) cannot connect to the report server database.

I was able to temporarily correct the problem by performing as iisrest on the Report Server/Database server. However, the same problem occured again a couple hours later. I am relatively new to SQL Reporting Services so any help would be appreciated.

MDJ

Well, the "Report Server (MSSQLSERVER) cannot connect to the report server database" error seems to have vanished but I am still receiving the "Message: An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
Attempted to read or write protected memory. This is often an indication that other memory is corrupt." error. Once whatever is causing this problem occurs, all users attempting to access SSRS from our ASP.NET application (using SOAP) receive the aforementioned error.

I have tried the following:

1. increased the MaxActiveReqForOneUser element in the RSWebApplication.config

2. Set the AppPool recycling setting for the ReportServer to run only once at a specified time (thinking perhaps the pool was recycling and corrputing session information).

Things I've noticed:

So far the only resolution for this issue is to perform an iisrest on the ReportServer.

This only seems to be an issue with reports being called using SOAP. Reports being rendering in the .NET Report Viewer control appear unaffected.

Here is some sample code to illustrate how we call some of our reports from ASP.NET through the SSRS web service:

************************************************************************************************************************************

Private callback As New System.Net.Security.RemoteCertificateValidationCallback(AddressOf RemoteCertificateValidationCallback)

Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
ByVal cert As System.Security.Cryptography.X509Certificates.X509Certificate, _
ByVal chain As System.Security.Cryptography.X509Certificates.X509Chain, _
ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean

Return True

End Function

Sub RenderReport()
Dim rs As New SQLReportingService.ReportingService
Dim results As [Byte]() = Nothing

System.Net.ServicePointManager.ServerCertificateValidationCallback = callback

rs.Credentials = New System.Net.NetworkCredential("User", "Password", "Domain")

results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF", Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing)

Response.Clear()
Response.Buffer = True
Response.Expires = 0
Response.ContentType = "application/pdf"
Response.AppendHeader("Content-Disposition", "attachment; filename=Report.pdf")
Response.BinaryWrite(results)
Response.End()
End Sub

**********************************************************************************************************************************************

Does anyone see a problem with the above code. It has been in production for 3 weeks now and has been working fine until yesterday. Any help would be greatly appreciated!