First published on TECHNET on Apr 29, 2015
The Service Manager setup allows the admin to install SQL Always on with default or with single instance name only and doesn’t provide flexibility to have multiple instance names. This limitation is with the fresh installation of Service Manager, but all SQL Always on scenarios work without any issue with migration of Database (including SQL Always On + FCI).
Please follow these steps to migrate SMDB to SQL Always On
Prepare the SQL Always on setup separately, you can also consider SQL Always On + FCI
Create an AGL (Availability Group Listener), provide the appropriate port number and avoid the default port 1433. For example AGL name =
and AGL Port =
Open the inbound port for SQL Server Instance and AGL on each SQL Server machine