Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

System Center 2012 R2

Posted on 2014-04-23
8
Medium Priority
?
1,223 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 2000 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

721 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