SSRS 2008 R2 DataCenter edition cannot be configured to use remote catalog database


For those who have SSRS 2008 R2 DataCenter edition RTM, you might quickly run into this bug when you are configuring remote catalog using the configuration tool:

The feature: “Remote access to report data sources and/or the report server database” is not supported in this edition of Reporting Services.

We will get this addressed in the next CU (CU4 I believe). But thanks to a colleague, a workaround using WMI is available.

 

# 1. Generating Scripts:

 

$RptSrv = gwmi -Namespace “root\Microsoft\SqlServer\ReportServer\RS_MSSQLServer\v10\Admin” -Class “MSReportServer_ConfigurationSetting”

$Res = $RptSrv.GenerateDatabaseCreationScript(“ReportServer”, 0, 1)

$Res.Script | Set-Content <Some File location>

 

# 2. Run the Script in the DB Server

 

# 3. Grant Permission to the user.

$ret = $RptSrv.GenerateDatabaseRightsScript(‘redmond\uipqac1’, ‘ReportServer’, 1,1)

$ret.Script | Set-Content <Some file location>

 

# Run the script on Report meta data server.

 

$RptSrv.SetDatabaseConnection(‘XXXXXX’, ‘ReportServer’, 0, ‘<USer Account>’, ‘<Password>’)

 

 

# on the other nodes execute the below steps.

$RptSrv = gwmi -Namespace “root\Microsoft\SqlServer\ReportServer\RS_MSSQLServer\v10\Admin” -Class “MSReportServer_ConfigurationSetting”

$RptSrv.SetDatabaseConnection(‘XXXXXX’, ‘ReportServer’, 0, ‘<USer Account>’, ‘<Password>’)

 


Comments (1)

  1. Satish says:

    Hi James,

    Can you please elaborate the steps to be run which are given above. On which server and from where to generate the script from step#1