InfoQi

To remove the SQL Server Reporting Services (SSRS) databases (ReportServer and ReportServerTempDB) using SQL Server Management Studio (SSMS), you must first ensure the associated Reporting Services is stopped, and then you can drop the databases like any other user database.

Stop the SSRS Service: Before attempting to delete the databases, you should stop the “SQL Server Reporting Services” service to prevent any active connections from blocking the deletion. You can do this via Windows Services (search for “Services” in the Start menu, find the service, right-click, and select Stop).

Method 1: Using Object Explorer (SSMS GUI)

1. Connect to your SQL Server instance in SQL Server Management Studio (SSMS).
2. In the Object Explorer pane, expand the Databases folder.
3. Right-click on the ReportServer database and select Delete.
4. In the Delete Object dialog box, confirm the correct database is selected and check the box to “Close existing connections” (if available/necessary).
5. Click OK.
6. Repeat the process for the ReportServerTempDB database.
7. Refresh the Databases folder to ensure the databases are no longer listed.

Method 2: Using Transact-SQL (T-SQL)

1. Connect to your SQL Server instance in SSMS.
2. Click “New Query” on the standard toolbar.
3. Ensure you are in the master database context (use the dropdown or type USE master; in the query window).
4. Copy and paste the following T-SQL commands into the query window: sql USE master; GO DROP DATABASE ReportServer; GO DROP DATABASE ReportServerTempDB; GO
5. Click Execute.

The databases will be permanently deleted. If you need to uninstall the SSRS feature or service from the server entirely (not just the databases), you must use the Windows Control Panel’s “Programs and Features” menu and the SQL Server setup wizard.