Post reply

uninstall report service native

  • August 17, 2018 at 4:47 am

    #371301

    Hello everyone
    I uninstalled the native reporting service component
    but despite that the reportserver base and ReportServerTempDB still exist on my instance

    Who has an idea please

  • August 17, 2018 at 5:05 am

    #2002208

    joujousagem2006 1602 - Friday, August 17, 2018 4:47 AM

    Hello everyone
    I uninstalled the native reporting service component
    but despite that the reportserver base and ReportServerTempDB still exist on my instance

    Who has an idea please

    The installer, and uninstaller, don't interact with the RDBMS, they only install the service and any relevant applications on the host machine. When you launch the SSRS Configuration Manager and set up the connections the databases would be created at that step. There are various reasons for this; for example SSRS can be installed on a different host machine to the DBMS thus trying to create a database on host machine without the SQL Server Data Engine installed would result in a installation failure if it were done at installation step.

    Similarly, when you uninstall the Service it doesn't DROP the databases. This might because you're migrating the service. Can you imagine how problematic it would be if you were migrating the service and uninstalling the service on your "old" server removed all your data for your new live server!?

    You have to therefore drop the databases yourself separately:
    USE master;
    GO
    ALTER DATABASE ReportServer SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    DROP DATABASE ReportServer;
    ALTER DATABASE ReportServerTempDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    DROP DATABASE ReportServerTempDB;

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply