N-central Troubleshooting

Report Manager 5 SP4 Install fails on ReportServer.dbo.ConfigurationInfo

Last Modified

Mon Sep 03 12:32 GMT 2018

Description

Report Manager Install failing

Error 27506. Error executing SQL Script Patch.config.500_5.0. Line 89. Invalid object name 'ReportServer.dbo.ConfigurationInfo'. (208)

Environment

N-able N-central Report Manager 5 SP4

Solution

The table or database is missing. In the example case, the server is missing the default ReportServer Database. Another cause could be a non-default database instancename.

Example: check for a database named "ReportServer"
SELECT name FROM master.sys.databases;

name
master
tempdb
model
msdb
DWDiagnostics
DWConfiguration
DWQueue
ReportServer1
ReportServer1TempDB
config
staging
warehouse

Example: show server instance name (should be MSSQLSERVER)
select @@servername + '\' + @@servicename;

NCREPORTS\MSSQLSERVER