Forum Discussion
Moving SQL Reporting Services Native Mode
I am trying to move a SQL Reporting Services database from a 2016 server to 2022. No problem, done this many times before. But on this one the source server in Reporting Services Configuration manager shows as Native, but once restored on the new server. When I run Reporting Services Configuration manager it pops up as Sharepoint.
Anyway to set it back to native mode? Please advise. Thanks!
JG
2 Replies
Somehow it must show something wrong.
SSRS 2016 was the last version supporting SharePoint Mode, in later versions (>= 2017) the feature was completley removed, see Reporting Services Report Server (SharePoint Mode) - SQL Server Reporting Services (SSRS) | Microsoft Learn
Appreciate the feedback. The original solution was SSRS2016. Currently if I look at that server under Reporting Configuration Manager it displays in "Native" mode.
If I backup and restore the reporting services databases to the new SQL 2022 server and run configuration manager there it tells me they are in Sharepoint mode. Is there anyway to get it back to Native mode?
