System Center Operations Manager 2016 Step by Step– Part 16 – Installing Reporting role on remote SQL installation? Missing SQL instance!?

The other day I was trying to install test SCOM 1801 environment and when I wanted to do reporting role installation I was stuck at this page. SQL Server instance for Reporting Services had empty SQL Server instance list. I scratched my had a little bit, but finally come to solution that is very obvious but somehow hidden and not enough explained. That is why some people doesn’t like SCOM because they can not get answers when they need it. Please if you have some piece of blog or Microsoft article that explain this comment. (I would like to have some reference) Closest one is article from Cameron Fuller. Even he had the same problem there.

 

image

 

So let me explain. When people are starting with SCOM or making test environments they take one big server and put everything there. SCOM installation, SQL database, SSRS and everything else needed for SCOM to work. IT works fine if you have enough resources. When it comes to production you usually take one server for SCOM roles and another one for SQL workloads. You start with installation and suddenly you come to this screen and there is no SQL Server instance available, even you know that everything is setup fine on SQL Server. You can even get remotely http://server/reports and http://server/reportserver pages. So what is the catch. 

YOU INSTALL SCOM REPORTING ROLE ON THE SERVER WHERE SSRS SERVICES ARE INSTALLED!

There is no other way. You can try but it doesn’t work and you will always get the same problem. You can manage to use remote SQL Reports database for examle, but SSRS service and Reporting role SCOM installation need to be on the same computer. There is also a catch for using reporting in web console but you can read it on another one of my  blogs https://igorpuhalo.wordpress.com/2017/03/16/system-center-operations-manager-2016-step-by-step-part-6/ 

In any case to repeat

YOU INSTALL SCOM REPORTING ROLE ON THE SERVER WHERE SSRS SERVICES ARE INSTALLED!

Like addition I will give you link to short Reporting book from Savision team “SCOM Reporting Guide – Tips and best practices”.

Advertisements

One thought on “System Center Operations Manager 2016 Step by Step– Part 16 – Installing Reporting role on remote SQL installation? Missing SQL instance!?

  1. Pingback: System Center Operations Manager 2016 Step by Step–Part 6 | IP loging

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