April 29, 2009 at 6:49 am
One of our servers has an old setup of SSRS that is no longer needed. At one point our previous DBA disabled the Service (SSRS) so it was no longer "functioning"
Last week I decided to clean up so I took both ReportServer and ReportServerTempDB offline with the intention of removing them if all went well. It didn't take long before I found complaints in the server's Application Event Log
The description for Event ID ( 107 ) in Source ( Report Server (MSSQLSERVER) ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer
This message continued even after I put both databases back online.
So today I decided to start the SSRS service on the server and it quickly started emailing report subscriptions so I shut it right down.
No more error messages being generated in the Event log.
So I have two questions:
Is there a logical group of steps to successfully remove reporting services?
Is there a good source of DB Schema information for SSRS subscriptions so I can disable any actually scheduled report generation before I turn it back on again?
April 29, 2009 at 8:16 am
You should find what you are looking for here.
http://msdn.microsoft.com/en-us/library/ms143518(SQL.90).aspx
April 29, 2009 at 8:43 am
Is it possible that you have a remote installation somewhere trying to access the databases? I had a similar situation where I took the databasese offline. It turns out that there was service running on another server trying to login into Report Server database. The error message was different, but I shut the remote service down, took the databases offline and then deleted them.
April 30, 2009 at 7:39 am
Thank you - good reference info.
April 30, 2009 at 7:45 am
You're welcome, glad to help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply