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 ...
Get Getting Started with Microsoft System Center Operations Manager now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
