Support of SQL Server AlwaysOn

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.

Parameter: sqlalwayson