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 for Search feature shown in Figure 2.5 is selected and this is something that a lot of people miss when deploying OpsMgr for the first time.

Figure 2.5: Choosing the Full Text Search feature

Tip

When selecting features for a new SQL instance,...