Skip to content

SCOM 2012 – Reset Reporting Services

January 15, 2013

From time to time i find installations for report services failing. Besides checking all the regular stuff it might be possible that the report service got damaged while installing Operations Manager.

ResetSRS2

You should know that installing reporting needs to be done on a dedicated SQL server or instance. This is because Operations Manager will replace all security settings.

A nice tool has been arround for a while and is to be found in the SupportTools on your source media is ResetSRS.exe. As the name says this tool is to be used for “resetting” the report services.

For executing the tool copy it to the SQL server (choose an easy path like c:\). Now open an elevated command prompt. Go to the location where the tool is and use it in combination with the instance name or SQL server name.

You will be prompted for credentials for an account that has enough permissions. The the tool will notify you when it succeeded.

ResetSRS1

Now hopefully the installation succeeds!

Advertisements

From → System Center

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: