Skype for Business. Move Central Management Store

skype-for-businessThere is a need to move Central Management Server to a new pool as the existing one is going to be decommissioned. SQL Backend consists of two MSSQL 2014 Servers running in AlwaysOn Cluster. While running Move-CsManagementServer commandlet with –WhatIf key I got an error:

Cannot move Central Management Server. The new Central Management Store located at “AlwaysOnListener.domain.com” is not accessible.

Needless to say that listener’s FQDN is available as well as both SQL servers. Permissions is not the case as well as I run that command under user with RTCUniversalServerAdmins group membership.The thing is that we don’t have xds and lis databases (which are Skype for Business Central Management Store Databases) on that SQL Cluster and Move-CsManagementServer commandlet can’t create them automatically. We have to use Install-CsDatabase cmdlet to create xds and lis databases. As we have AlwaysOn cluster we need to run Install-CsDatabase separately for each server in cluster and NOT for SQL listener FQDN.

The output should be similar to this:

install-csdatabase

If errors occured you can revise details in corresponding C:\Report… file.

Now we have xds and lis databases on both servers.

MSSQL-2014-skype-for-businessLet’s make them highly available and add to AlwaysOn High Availability Group. To do so first of all we have to delete these databases from Secondary Replica of AlwaysOn Availability Group. In other case we will get this error while adding the databases to High Availability Group:

database-already-exist

Right click on database name and choose “Delete” then OK. If “Object is in use” error appears check “Close existing connections” checkbox at the bottom of “Delete Object” page.

Now prepare databases: set recovery model to “Full”

MSSQL-set-recovery-modeland make Backup of xds and lis databases:

mssql-backup-databasemssql-backup-database-full

Now you are ready to add database to AlwaysOn High Availability Group.

Expand “AlwaysOn High Availability”, expand “Availability Groups” and right click on the name of availability group you are trying to add databases to. Check databases you want to add. Make sure they “Meets prerequisites”:

add-database-to-high-availability-groupComplete the wizard. Make sure all databases are now in “Syncronized” state.

Now run

cmdlet and make sure the error is gone!

Remember that you MUST run Move-CsManagementServer cmdlet locally on the server you are moving Central Management Store to. Remote PowerShell session will not work!

Be sociable 🙂 Share!
error

Comments/Коментарі/Комментарии