Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.50

Administer > Database Administration > Support of SQL Server AlwaysOn

Support of SQL Server AlwaysOn

HPE Service Manager supports SQL Server AlwaysOn for SQL Server 2012 and later versions. As a high availability solution for SQL Server databases, AlwaysOn refers to two separate but related technologies: AlwaysOn Failover Clustering and AlwaysOn Availability Groups. For more information, refer to the Microsoft SQL Server documentation.

To support SQL Server AlwaysOn, make sure your Service Manager environment meets the following conditions:

Microsoft ODBC Driver 11 for SQL Server (or a later version) is installed. You can download it from the Microsoft website.

Caution Do not use the ODBC SQL Server Driver or SQL Server Native Client ODBC Driver.
A system DSN is added using Microsft ODBC Driver 11 for SQL Server (or later).

Pay special attention to the following settings when creating the system DSN:
- You must select ODBC Driver 11 for SQL Server (or later).
- In the Server field, you must specify the SQL availability group client access point (for example, SqlFailOver), instead of the SQL Server instance. You need to create a client access point when enabling AlwaysOn for the SQL Server database cluster.
- You must select the Multi-subnet failover option.
The following lines are added in the Service Manager Server configuration file (sm.ini):
```
sqlalwayson:1
sqllibrary:SQMSSQLAO.ODBC.DLL
```
The sm.ini file should resemble the following example:
```
[sqlserver]
sqldb:xxxx
*sqllogin:xxxxxx
sqlalwayson:1
sqllibrary:SQMSSQLAO.ODBC.DLL
```

For detailed steps to set up SQL Server AlwaysOn for Service Manager, refer to the Enabling SQL Server AlwaysOn for Service Manager white paper.

Send Help Center feedback