CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2012
Vignesh Subramanian
Vignesh Subramanian

Reputation: 7289

Unable to delete ghost server from dbo.keys in SQL Server

I am getting this error in the SSRS

SSRS: The feature: “Scale-out deployment” is not supported in this edition of Reporting Services.

So I tried to delete an entry from dbo.keys as suggested in multiple forums.

delete from keys 
where MachineName = 'YourGhostServer'

But, the entry is appearing again once I restart the services

Upvotes: 1

Views: 924

Answers (1)

Thom A
Thom A

Reputation: 95949

I'm guessing you've restored a copy of the ReportServer DB from another instance or similar?

If you open the Reporting Services Configuration Manager, and connect to your instance, how many servers do in see in the Scale-out Deployment screen? If 2, then select the one that shouldn't be there and click Remove Server. (Screen from a 2012 instance, that doesn't have 2 servers; yours should look similar):

enter image description here

Upvotes: 1

Related Questions