How to: Uninstall an Instance of Reporting Services
You can use Setup to uninstall SQL Server Reporting Services or remove specific components. Both the Installation Wizard and command line setup can be used to remove or modify an existing installation. If you choose to remove an entire installation, some files and accounts will remain after Setup is finished. Databases, log files, report definition files, model files, project files, solutions, and jobs waiting to be processed must be removed manually. The steps in this topic provide instructions on how to delete items that are not removed when you uninstall the software. To delete scheduled report processes that are currently in the queue, see Viewing and Modifying Jobs.
If you have installed 32-bit and 64-bit versions of Reporting Services on the same computer, be sure to use the 64-bit version of Setup to uninstall the 64-bit version of Reporting Services. You cannot use the 32-bit version of Setup to uninstall 64-bit Reporting Services.
To remove the report server databases
Use Management Studio or Enterprise Manager (if you are using SQL Server 2000 to host the database) to connect to the SQL Server Database Engine instance that hosts the databases.
Delete the databases. If you used default names, the database names are reportserver and reportservertemp. To verify the actual file names, you can run the Reporting Services Configuration tool and view the database name in the Database Setup page.
Delete the database role RSExecRole from Master and MSDB manually.
To delete data files
Search the hard drive for the following file types:
Report definition (.rdl) files, semantic model (.smdl) files, shared data source (.rds) files, report project (.rptproj) files, solutions (.sln) files.
Delete the files.
To delete samples
- Use Add or Remove Programs to uninstall the Reporting Services sample reports and applications. Setup uninstalls only the files it added. If additional user option files are created, or if you add new files to this folder, those files remain after the uninstall operation is finished. Sample files are located at Tools\Samples\<lang>\ReportingServices.
To delete log files
Navigate to the Log Files folder. Log files are located at Reporting Services\Log Files.
Delete the files.