O'Reilly logo

Getting Started with Microsoft System Center Operations Manager by Kevin Greene

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tips for deploying SQL

Before you can install OpsMgr, you need to deploy a SQL environment to host the databases. A full installation of SQL is relatively straight-forward and you can refer to http://tinyurl.com/sqlinstall for a step-by-step walkthrough of SQL 2014 (the steps in this link are also applicable for SQL 2012 R2 and SQL 2016).

There are however, a few pointers that you need to take into account when deploying SQL with OpsMgr and this section will help you avoid some of the common pitfalls that people encounter.

SQL features and collation setting

During the installation of SQL, you will be asked to choose the features that you want installed into your new instance. A database requirement of OpsMgr is that the Full-Text and Semantic Extractions ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required