Solved

System Center 2012 R2

Posted on 2014-04-23
8
1,127 Views
Last Modified: 2014-07-16
I am installing System Center 2012 R2. I have installed SQL 2012 R2 with all the default values. I have installed and confirmed all the prerequisites have passed. I am installing everything on a single server which is running Windows 2012 R2 Datacenter.

During the installation everything goes fine. For both the operational database and database wharehouse I enter just the server name in the field for Server Name and Instance Name. Both of these are accepted.

When I get to the next section SQL Server Instance for Reporting Services there is the drop down to select the SQL Server Instance. I am presented with only one option which is the same name of my server. However when I select this it is not accepted. I get the RED X.

I have disabled the windows firewall, confirm that system center 2012 R2 and SQL Server 2012 R2 are compatible.

Has anyone entered the same problem.
0
Comment
Question by:carloc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 12

Expert Comment

by:Infamus
ID: 40018372
It should give you the explanation when you hover the mouse point over to the red X.
0
 

Author Comment

by:carloc
ID: 40018385
The is explanation given, but I have confirmed that System Center 2012 R2 works with SQL 2012 R2. Windows firewall is also turned off.

The installed version of SQL Server could not be verified or is not supported. Verify that the computer and the installed version of SQL Server meet the minimum requirements for installation, and that the firewall settings are correct. See the Supported Configurations document for further information.
0
 
LVL 12

Accepted Solution

by:
Infamus earned 500 total points
ID: 40018411
Try this...

To resolve this problem, open a Command Prompt window, select Run as administrator, and then run the following command. In the command, replace the <path> placeholder with the location of SQL Server:
mofcomp.exe “<path>\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Author Comment

by:carloc
ID: 40018710
Infamus, I ran the command that you have given. The command completed succesfully. The only difference is that I could only find the sqlmgmproviderxp2pup.mof file in the following path. I found it in the 110 directory and not the 100 directory.

C:\Program Files (x86)\Microsoft SQL Server\110\Shared

However when I tried to install the Reporting services for System Center I got the same result as before.
0
 
LVL 12

Expert Comment

by:Infamus
ID: 40018721
Can you go over these steps and make sure you are following the correct steps?

http://ajituelegi.wordpress.com/2012/12/01/scom-2012-installation-part-ii/
0
 
LVL 12

Expert Comment

by:Infamus
ID: 40018736
Also take a look at the installation logs located in %LocalAppData%\SCOM\Logs
0
 

Author Comment

by:carloc
ID: 40020834
Infamus,
thanks for your advice. I have finished installing all other components for System Center 2012. Since I don't think that the reporting feature is going to be a show stopper I will be waiting a while before trying to install this.

I checked the log files and there where no error messages that helped with this problem.
0
 

Author Closing Comment

by:carloc
ID: 40200611
Thanks for your help with the installation. I finished it a while back but forgot to close out my question.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article summaries thoughts and ideas from two years of sustained use. It provides good reasoning to make the jump to Windows 10.
Determining the an SCCM package name from the Package ID
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question