Setting up & Configuring SQL Server to support your SCCM & SCOM environment « System Center Operations Manager « Downloads

Date postedJune 2, 2012
Downloaded125 times
CategoriesSystem Center Operations Manager
Tagsslidedeck, community day, presentation, session, sql, opsmgr r2, opsmgr, scom


Center Configuration Manager and Operations Manager both need SQL
Server. In this session we will show you what the best practices are
for having a smooth running SQL server for our System Center
environment. Having a good initial setup and configuration is not the
only important thing, doing regular health checks on your SQL server is
even more important. In this session we will discuss just about
anything you need to know about setting up SQL from the SCOM or SCCM
admin perspective. In this session you will learn how to work with the
SQL team and set up your scom or sccm to talk with their standard SQL
setup. This includes setups with remote sql servers, sql server
services running as domain users, and named instances. Additionally we
will talk about some SQL related configuration topics, like network
libraries, firewall configuration, SQL collations, database recovery
models and authentication modes.

At the end of this session you will know everything you need to know about SQL setup to support your scom or sccm environment.

Speaker: Kim Oppalfens & Alexandre Verkinderen