SCOM 2012 Installation does not show the SQL Server Instance for reporting services
I have an issue when I try to install SCOM 2012 with the Reporting Server feature, so in the step that I have to select a SQL Server Instance I cannot do that, because as you can see in the picture no one option appears. In my scenario I have a DCSERVER, SQLSERVER2008 R2, SCCMSERVER 2012 and in other server I are trying to install SCOM 2012. I are trying to use the same SQLSERVER to SCOM 2012. Should I do other procedure on SQL Server before to continue? I will apreciate someone could say me what I need to do to resolve this issue. Regards, Paul Mendoza.
January 13th, 2012 1:31pm

Hi, Perhaps Kevin can help you: http://blogs.technet.com/b/kevinholman/archive/2011/07/26/deploying-opsmgr-2012-a-quick-start-guide.aspx Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
January 13th, 2012 2:05pm

Hi Paul Can you confirm that SQL Reporting Services is installed on the server that you are doing the install. For a lab environment where you have SCOM Management Server, Web Server on one server and SQL Server on another you need to: - run setup on the SCOM Server and choose NOT to install reporting. The install here will create the OperationsManager database and OperationsManagerDW (reporting) database. - run setup on the SQL Server where SQL Reporting Services is installed. Then choose to install reporting. You should then see the SQL Reporting Services instance on the above window which is blank in your screenshot. Take note of the warning in that window - SCOM uses its own role based security within SQL Reporting Services and this can break other reporting. E.g. you can't install SCOM and SCSM reporting (SQL RS component) together. Cheers GrahamNew SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/ View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
January 14th, 2012 6:58am

Hello Graham, I have tried to install SCOM in the same server that I have SQL and SCOM 2012 shows the SQL Server Instance for reporting services like you have mentioned. However, the installation does not finish. I have a question, if I want to have in the same scenario SCCM 2012 and SCOM 2012, Must I have a SQL server for each one (I mean a SQL server to SCCM Server 2012 and another one SQL server to SCOM Server 2012) or Can I have both products in one SQL server? Thanks in advance. Best Regards, Paul Mendoza.
Free Windows Admin Tool Kit Click here and download it now
January 16th, 2012 2:30pm

Hi all, i have the same problem with SQL instance. We have 3 different servers - SQL Server, SCCM and SCOM. I have trouble by installing SCOM reporting services. The problem is, when i get to the page for installing SQL server instance for reporting services the dropdown list is blank. Graham Davies, how do you mean that - "E.g. you can't install SCOM and SCSM reporting (SQL RS component) together. " ? That's mean, that I must install SCOM reporting services on the same server with SQL and not with SCOM ? Ninja 4 IT
June 19th, 2012 7:45am

i am having the same issue .. Paul can you please help .. i created a new instance also but still i am not getting any instance name.. stuck from last 2 days ... plz help Thanks Happiness Always Jatin
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2012 4:15am

Just install SSRS instance locally on SCOM server, and configure SSRS on SCOM server.-- Cdric GEORGEOT [MVP] Virtual Machine http://www.e-novatic.fr -- Auteur du livre "Bonnes pratiques, planification et dimensionnement des infrastructures de stockage et de serveur en environnement virtuel" -- N'oubliez pas de marquer comme rponse ;-)
August 8th, 2012 4:52pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics