Solved

Required SQL databases for SCOM 2012

Posted on 2014-01-05
4
553 Views
Last Modified: 2014-01-18
I need to install SCOM 2012 in windows 2012 server. I believe SCOM 2012 requires SQL databases.
in our environment we have a separate team that takes cares of SQL servers and databases.
I might have to make a request to SQL team and ask them which databases ,accounts,and account permissions they should create on SQL server.(SQL server is in separate windows server from where SCOM will be installed)

Now that I cannot touch SQL servers, I would like to know what I need as a request for SQL team, in order to get SCOM 2012  have everything it needs in SQL server, before I start SCOM2012 install on my windows 2012 server.

Any help will be very much appreciated.

Thank you
0
Comment
Question by:jskfan
  • 3
4 Comments
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 39760984
the concept has changed a bit
check:
Deploying System Center 2012 - Operations Manager
http://technet.microsoft.com/en-us/library/hh298609.aspx
0
 

Author Comment

by:jskfan
ID: 39763660
I see:
 OperationsManager
 OperationsManagerDW

is that all ?
0
 

Author Comment

by:jskfan
ID: 39790807
I guess these DB are mandatory, as they get created automatically when installing SCOM.



OperationsManager
 OperationsManagerDW
0
 

Author Closing Comment

by:jskfan
ID: 39790808
Thanks
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Using a hta file with MSSQL agent to schedule a script job 4 41
Windows Server 2012 R2 vs. Windows Server 2016 feature comparison ? 3 68
sql server query 18 42
DNS zone 3 28
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

828 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