Hello, I am upgrading a stand-alone SQL 2008 Ent. to SQL 2008 R2 Ent. The server has two Reporting Services databases. The RS service itself is on another server. I normally do not do in-place upgrades, do an uninstall and reinstall instead. But, now there are additional roles on master and msdb databases, and maybe some other objects. What would be the best way to do the upgrade with minimal affect on Reporting Services? Thanks, Kuzey

Correct me if I'm wrong but you are updating just the SQL Engine where the Reporting Services Databases are, if that is the case the only things you should do are the regular safeguard steps for any infrastructure operation with Reporting Services. Take a backup of the Reporting Services Databases Take a backup of the Reporting Services encryption key Stop the Reporting Services Service before the upgrade and start it after the upgrade finish just to avoid Reporting Services try to connect to the Databases meanwhile the upgrade is in progress. You should not have any particular issue as Reporting Services works wtih different SQL Engine versions for the Catalog Jaime - http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights

Thanks, Jaime. We are upgrading both the SQL Engine (with RS databases) and the Reporting Services which is on another box. Any change in your plan other than upgrading RS itself as well? Kuzey

From the things I have seen I would say you will not have any issue, just do it in sequence (whichever you prefer to update first) Jaime - http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights

I also found this link that can be useful for you: Considerations for Upgrading Reporting Services http://msdn.microsoft.com/en-us/library/ms143747.aspx Jaime -http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights

I did the following; - Uninstall Data Engine - Install 2008 R2 and SP1 Data Engine - Restore Reporting Services databases - In-place upgrade Reporting Services on the other box - The RS service started up fine and I use Local Account to connect to RS Databases (as before) - Now I get the following error when I try to RESTORE ENCRYPTION KEYS; Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation. ---> System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo) at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, String password) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, String password) Any idea? Thanks, Kuzey

You should not need to restore the encryption key in the In-place upgrade, does Reporting Services Work currenlty? The error that you mention is usually due the Reporting Services Service is not started, check the RS error logs to see if there is any entry that shows the service is not working properly. Jaime -http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights

You should not need to restore the encryption key in the In-place upgrade, does Reporting Services Work currenlty? The error that you mention is usually due the Reporting Services Service is not started, check the RS error logs to see if there is any entry that shows the service is not working properly. Jaime -http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights

I can stop/start the RS service from both Windows Services and RS Config Tool with no error. I checked the report server trace log. Here's what it has before I attempt to Restore Keys; <Header> <Product>Microsoft SQL Server Reporting Services Version 2009.0100.2500.00 ((KJ_PCU_Main).110617-0038 )</Product> <Locale>English (United States)</Locale> <TimeZone>Eastern Daylight Time</TimeZone> <Path>D:\MSSQL\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__10_28_2011_17_24_23.log</Path> <SystemName>AL3C5Q-V05</SystemName> <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName> <OSVersion>6.0.6002</OSVersion> <ProcessID>2804</ProcessID> <Virtualization>Hypervisor</Virtualization> </Header> ... resourceutilities!DefaultDomain!1420!10/28/2011-17:24:24:: i INFO: Reporting Services starting SKU: Enterprise configmanager!DefaultDomain!1420!10/28/2011-17:24:24:: i INFO: Using report server internal url http://localhost:80/ReportServer. configmanager!DefaultDomain!1420!10/28/2011-17:24:24:: i INFO: Using report server external url http://xxx:80/ReportServer. configmanager!DefaultDomain!1420!10/28/2011-17:24:24:: i INFO: Using url root http://xxx:80/ReportServer. appdomainmanager!DefaultDomain!1420!10/28/2011-17:24:24:: i INFO: Appdomain:2 WindowsService_0 started. library!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Catalog SQL Server Edition = Enterprise crypto!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM crypto!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Exporting public key crypto!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Performing sku validation crypto!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Importing existing encryption key dbpolling!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: EventPolling polling service started dbpolling!WindowsService_0!14f0!10/28/2011-17:24:25:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started. dbpolling!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: NotificationPolling polling service started dbpolling!WindowsService_0!128c!10/28/2011-17:24:25:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started. dbpolling!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: SchedulePolling polling service started dbpolling!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: UpgradePolling polling service started dbpolling!WindowsService_0!1640!10/28/2011-17:24:25:: i INFO: PollingMaintenance: Polling started resourceutilities!WindowsService_0!1640!10/28/2011-17:24:25:: i INFO: Maximum memory limit is 2097152Mb rpcserver!DefaultDomain!7b4!10/28/2011-17:24:25:: i INFO: RPC Server started. servicecontroller!DefaultDomain!7b4!10/28/2011-17:24:25:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.MSSQLSERVER' appdomainmanager!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Appdomain:2 WindowsService_0 initialized. rshost!rshost!7b4!10/28/2011-17:24:25:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=D:\MSSQL\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer. rshost!rshost!7b4!10/28/2011-17:24:25:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2 rshost!rshost!7b4!10/28/2011-17:24:25:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=D:\MSSQL\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager. rshost!rshost!7b4!10/28/2011-17:24:25:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3 rshost!rshost!7b4!10/28/2011-17:24:25:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=D:\MSSQL\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder. resourceutilities!DefaultDomain!1420!10/28/2011-17:24:25:: i INFO: Maximum memory limit is 2097152Mb rshost!rshost!1420!10/28/2011-17:24:25:: i INFO: Derived memory configuration based on physical memory as 4192868 KB servicecontroller!DefaultDomain!7b4!10/28/2011-17:24:25:: i INFO: Total Physical memory: 4293496832 rpcserver!DefaultDomain!e64!10/28/2011-17:24:25:: i INFO: Process monitoring started. library!DefaultDomain!1700!10/28/2011-17:24:26:: i INFO: Catalog SQL Server Edition = Enterprise

I can stop/start the RS service from both Windows Services and RS Config Tool with no error. I checked the report server trace log. Here's what it has before I attempt to Restore Keys; <Header> <Product>Microsoft SQL Server Reporting Services Version 2009.0100.2500.00 ((KJ_PCU_Main).110617-0038 )</Product> <Locale>English (United States)</Locale> <TimeZone>Eastern Daylight Time</TimeZone> <Path>D:\MSSQL\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__10_28_2011_17_24_23.log</Path> <SystemName>AL3C5Q-V05</SystemName> <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName> <OSVersion>6.0.6002</OSVersion> <ProcessID>2804</ProcessID> <Virtualization>Hypervisor</Virtualization> </Header> ... resourceutilities!DefaultDomain!1420!10/28/2011-17:24:24:: i INFO: Reporting Services starting SKU: Enterprise configmanager!DefaultDomain!1420!10/28/2011-17:24:24:: i INFO: Using report server internal url http://localhost:80/ReportServer. configmanager!DefaultDomain!1420!10/28/2011-17:24:24:: i INFO: Using report server external url http://xxx:80/ReportServer. configmanager!DefaultDomain!1420!10/28/2011-17:24:24:: i INFO: Using url root http://xxx:80/ReportServer. appdomainmanager!DefaultDomain!1420!10/28/2011-17:24:24:: i INFO: Appdomain:2 WindowsService_0 started. library!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Catalog SQL Server Edition = Enterprise crypto!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM crypto!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Exporting public key crypto!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Performing sku validation crypto!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Importing existing encryption key dbpolling!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: EventPolling polling service started dbpolling!WindowsService_0!14f0!10/28/2011-17:24:25:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started. dbpolling!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: NotificationPolling polling service started dbpolling!WindowsService_0!128c!10/28/2011-17:24:25:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started. dbpolling!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: SchedulePolling polling service started dbpolling!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: UpgradePolling polling service started dbpolling!WindowsService_0!1640!10/28/2011-17:24:25:: i INFO: PollingMaintenance: Polling started resourceutilities!WindowsService_0!1640!10/28/2011-17:24:25:: i INFO: Maximum memory limit is 2097152Mb rpcserver!DefaultDomain!7b4!10/28/2011-17:24:25:: i INFO: RPC Server started. servicecontroller!DefaultDomain!7b4!10/28/2011-17:24:25:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.MSSQLSERVER' appdomainmanager!WindowsService_0!7b4!10/28/2011-17:24:25:: i INFO: Appdomain:2 WindowsService_0 initialized. rshost!rshost!7b4!10/28/2011-17:24:25:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=D:\MSSQL\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer. rshost!rshost!7b4!10/28/2011-17:24:25:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2 rshost!rshost!7b4!10/28/2011-17:24:25:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=D:\MSSQL\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager. rshost!rshost!7b4!10/28/2011-17:24:25:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3 rshost!rshost!7b4!10/28/2011-17:24:25:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=D:\MSSQL\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder. resourceutilities!DefaultDomain!1420!10/28/2011-17:24:25:: i INFO: Maximum memory limit is 2097152Mb rshost!rshost!1420!10/28/2011-17:24:25:: i INFO: Derived memory configuration based on physical memory as 4192868 KB servicecontroller!DefaultDomain!7b4!10/28/2011-17:24:25:: i INFO: Total Physical memory: 4293496832 rpcserver!DefaultDomain!e64!10/28/2011-17:24:25:: i INFO: Process monitoring started. library!DefaultDomain!1700!10/28/2011-17:24:26:: i INFO: Catalog SQL Server Edition = Enterprise

After I attempt to Restore Keys; rpcserver!DefaultDomain!1700!10/28/2011-17:26:54:: i INFO: RPC Server stopped. servicecontroller!DefaultDomain!1700!10/28/2011-17:26:54:: i INFO: RPC Server stopped. rshost!rshost!1700!10/28/2011-17:26:54:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2 rshost!rshost!1700!10/28/2011-17:26:54:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3 rshost!rshost!1700!10/28/2011-17:26:54:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=D:\MSSQL\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder. rshost!rshost!7b4!10/28/2011-17:26:54:: i INFO: Derived memory configuration based on physical memory as 4192868 KB servicecontroller!DefaultDomain!7b4!10/28/2011-17:26:54:: i INFO: Recycling the service from the default domain dbpolling!WindowsService_0!1700!10/28/2011-17:26:54:: i INFO: EventPolling polling service stopped dbpolling!WindowsService_0!14f0!10/28/2011-17:26:54:: i INFO: HeartbeatThread(EventPolling): Exited. dbpolling!WindowsService_0!1700!10/28/2011-17:26:54:: i INFO: NotificationPolling polling service stopped dbpolling!WindowsService_0!128c!10/28/2011-17:26:54:: i INFO: HeartbeatThread(NotificationPolling): Exited. dbpolling!WindowsService_0!1700!10/28/2011-17:26:54:: i INFO: SchedulePolling polling service stopped dbpolling!WindowsService_0!1700!10/28/2011-17:26:54:: i INFO: UpgradePolling polling service stopped rshost!rshost!7b4!10/28/2011-17:27:09:: i INFO: Application domain type WindowsService statistics: created: 1, unloaded: 1, failed: 0, timed out: 0. appdomainmanager!DefaultDomain!7b4!10/28/2011-17:27:09:: i INFO: Appdomain:3 WindowsService_1 started. resourceutilities!WindowsService_1!7b4!10/28/2011-17:27:10:: i INFO: Reporting Services starting SKU: Enterprise library!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Catalog SQL Server Edition = Enterprise crypto!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM crypto!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Exporting public key crypto!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Performing sku validation crypto!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Importing existing encryption key servicecontroller!WindowsService_0!7b4!10/28/2011-17:27:10:: i INFO: Service controller exiting. dbpolling!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: EventPolling polling service started appdomainmanager!DefaultDomain!7b4!10/28/2011-17:27:10:: i INFO: Appdomain:2 unregistered. appdomainmanager!DefaultDomain!7b4!10/28/2011-17:27:10:: i INFO: Appdomain:2 WindowsService_0 unloading. dbpolling!WindowsService_1!1700!10/28/2011-17:27:10:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started. dbpolling!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: NotificationPolling polling service started appdomainmanager!DefaultDomain!15c0!10/28/2011-17:27:10:: i INFO: AppDomain:2 0 pending unload(s) dbpolling!WindowsService_1!1240!10/28/2011-17:27:10:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started. dbpolling!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: SchedulePolling polling service started dbpolling!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: UpgradePolling polling service started dbpolling!WindowsService_1!15c0!10/28/2011-17:27:10:: i INFO: PollingMaintenance: Polling started resourceutilities!WindowsService_1!15c0!10/28/2011-17:27:10:: i INFO: Maximum memory limit is 2097152Mb rpcserver!DefaultDomain!15c4!10/28/2011-17:27:10:: i INFO: RPC Server started. servicecontroller!DefaultDomain!15c4!10/28/2011-17:27:10:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.MSSQLSERVER' appdomainmanager!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Appdomain:3 WindowsService_1 initialized.

After I attempt to Restore Keys; rpcserver!DefaultDomain!1700!10/28/2011-17:26:54:: i INFO: RPC Server stopped. servicecontroller!DefaultDomain!1700!10/28/2011-17:26:54:: i INFO: RPC Server stopped. rshost!rshost!1700!10/28/2011-17:26:54:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2 rshost!rshost!1700!10/28/2011-17:26:54:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3 rshost!rshost!1700!10/28/2011-17:26:54:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=D:\MSSQL\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder. rshost!rshost!7b4!10/28/2011-17:26:54:: i INFO: Derived memory configuration based on physical memory as 4192868 KB servicecontroller!DefaultDomain!7b4!10/28/2011-17:26:54:: i INFO: Recycling the service from the default domain dbpolling!WindowsService_0!1700!10/28/2011-17:26:54:: i INFO: EventPolling polling service stopped dbpolling!WindowsService_0!14f0!10/28/2011-17:26:54:: i INFO: HeartbeatThread(EventPolling): Exited. dbpolling!WindowsService_0!1700!10/28/2011-17:26:54:: i INFO: NotificationPolling polling service stopped dbpolling!WindowsService_0!128c!10/28/2011-17:26:54:: i INFO: HeartbeatThread(NotificationPolling): Exited. dbpolling!WindowsService_0!1700!10/28/2011-17:26:54:: i INFO: SchedulePolling polling service stopped dbpolling!WindowsService_0!1700!10/28/2011-17:26:54:: i INFO: UpgradePolling polling service stopped rshost!rshost!7b4!10/28/2011-17:27:09:: i INFO: Application domain type WindowsService statistics: created: 1, unloaded: 1, failed: 0, timed out: 0. appdomainmanager!DefaultDomain!7b4!10/28/2011-17:27:09:: i INFO: Appdomain:3 WindowsService_1 started. resourceutilities!WindowsService_1!7b4!10/28/2011-17:27:10:: i INFO: Reporting Services starting SKU: Enterprise library!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Catalog SQL Server Edition = Enterprise crypto!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM crypto!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Exporting public key crypto!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Performing sku validation crypto!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Importing existing encryption key servicecontroller!WindowsService_0!7b4!10/28/2011-17:27:10:: i INFO: Service controller exiting. dbpolling!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: EventPolling polling service started appdomainmanager!DefaultDomain!7b4!10/28/2011-17:27:10:: i INFO: Appdomain:2 unregistered. appdomainmanager!DefaultDomain!7b4!10/28/2011-17:27:10:: i INFO: Appdomain:2 WindowsService_0 unloading. dbpolling!WindowsService_1!1700!10/28/2011-17:27:10:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started. dbpolling!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: NotificationPolling polling service started appdomainmanager!DefaultDomain!15c0!10/28/2011-17:27:10:: i INFO: AppDomain:2 0 pending unload(s) dbpolling!WindowsService_1!1240!10/28/2011-17:27:10:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started. dbpolling!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: SchedulePolling polling service started dbpolling!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: UpgradePolling polling service started dbpolling!WindowsService_1!15c0!10/28/2011-17:27:10:: i INFO: PollingMaintenance: Polling started resourceutilities!WindowsService_1!15c0!10/28/2011-17:27:10:: i INFO: Maximum memory limit is 2097152Mb rpcserver!DefaultDomain!15c4!10/28/2011-17:27:10:: i INFO: RPC Server started. servicecontroller!DefaultDomain!15c4!10/28/2011-17:27:10:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.MSSQLSERVER' appdomainmanager!WindowsService_1!15c4!10/28/2011-17:27:10:: i INFO: Appdomain:3 WindowsService_1 initialized.

Is your Reporting Services Working?

Is your Reporting Services Working? I dont really know how to check. I tried to access the reports using link from RS Config Tool but I could access. Should not I be able to Restore Keys on a working RS environment?

Is your Reporting Services Working? I dont really know how to check. I tried to access the reports using link from RS Config Tool but I could access. Should not I be able to Restore Keys on a working RS environment?

Yes you should be able to do it, but there is not need of it on the in place upgrade From your logs looks like you are running Reporting Services properly I am wondering if is just you restore that doesn't work or of it's something else Can you backup the key?

Yes you should be able to do it, but there is not need of it on the in place upgrade From your logs looks like you are running Reporting Services properly I am wondering if is just you restore that doesn't work or of it's something else Can you backup the key?

Yes, I could backup the key both before and after the upgrade.

Yes, I could backup the key both before and after the upgrade.

From the logs and from your information looks like your environment is working properly, but please file a bug in http://connect.microsoft.com/ so you can upload logs and details for the issue restoring a backup of the encryption key. Jaime -http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights

From the logs and from your information looks like your environment is working properly, but please file a bug in http://connect.microsoft.com/ so you can upload logs and details for the issue restoring a backup of the encryption key. Jaime -http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights