Community Day Session: Setting up & Configuring SQL Server to support your SCCM & SCOM environment

Kim Oppalfens and I did a session at community day together:

Setting up & Configuring SQL Server to support your SCCM & SCOM environment

System 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

 

Slide Deck: http://scug.be/media/p/1136.aspx 

---

Pictures:

---

---

See you next year!

Alexandre Verkinderen