Showing posts with label receiving. Show all posts
Showing posts with label receiving. Show all posts

Friday, March 9, 2012

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'

Saturday, February 25, 2012

Report Server Database is an invalid version

We have been receiving these errors and are not sure why. The Reporting
Server has RS SP1 and the latest SQL Server service pack (SP3a). The webiste
is serving up reports with no problem. Thanks.
Event Type: Error
Event Source: Schedule and Delivery Processor
Event Category: Startup/Shutdown
Event ID: 117
Date: 10/19/2004
Time: 2:36:58 AM
User: N/A
Computer: ProdServer
Description:
The report server database is an invalid version.Does RS work correctly when you browse to //localhost/reportserver? What
user is the reportserver service running as?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"troy" <troy@.discussions.microsoft.com> wrote in message
news:04512DEC-7E0E-494A-9201-739E135A2885@.microsoft.com...
> We have been receiving these errors and are not sure why. The Reporting
> Server has RS SP1 and the latest SQL Server service pack (SP3a). The
webiste
> is serving up reports with no problem. Thanks.
> Event Type: Error
> Event Source: Schedule and Delivery Processor
> Event Category: Startup/Shutdown
> Event ID: 117
> Date: 10/19/2004
> Time: 2:36:58 AM
> User: N/A
> Computer: ProdServer
> Description:
> The report server database is an invalid version.|||Hi, I used to face the same problem, until I created a Virtual Directory/Database using the SQL Server Config Wizard. Since, then, the error has stopped occuring.
From http://www.developmentnow.com/g/115_2004_10_0_0_452074/Report-Server-Database-is-an-invalid-version.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

REPORT SERVER

Hi - I am trying to access the report server installed by SQL2005 for the first time and keep receiving this error message: using url -http://localhost/reports

Failed to map the path '/Reports/App_GlobalResources/

Have you gone through the configuration yet?

Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > Reporting Services Configuration

I hope this helps