I’m struggling with a problem in SSRS. Every time I start it up, I get an error saying the scale-out deployment feature isn’t supported in my version.
People online said I should remove an entry from the dbo.keys table to fix this. So I tried running a delete command to get rid of the ghost server. But it’s not working! The entry keeps coming back after I restart the services.
Here’s what I’ve tried:
DELETE FROM ReportServerTable
WHERE ServerName = 'PhantomMachine'
Does anyone know why this isn’t working? Is there another way to permanently remove this ghost server entry? I’m really stuck and could use some help!
Have you considered investigating potential triggers or stored procedures that might be automatically recreating the entry? It’s possible there’s some underlying process reintroducing the ghost server upon service restart. Another approach could be to examine the ReportServer database for any related tables or views that might be linked to this issue. Additionally, reviewing the SSRS configuration files and ensuring they align with your desired setup might reveal the root cause. If all else fails, a complete uninstall and reinstall of SSRS could potentially resolve the persistent entry problem, though that should be a last resort.
hmmm, that’s a tricky one! have u tried checking the configuration files? sometimes those pesky settings can override database changes. maybe there’s sumthing in there that’s re-adding the ghost server? also, are u sure you’re deleting from the right table? might be worth double-checking that too. what happens if u try disabling the scale-out feature entirely?