Thursday 20 February 2020

Unable to install CMS database for skype for business 2015 in SQL server 2016

Have recently migrated from Lync server 2010 to Skype for business 2015. All users migrated to skype for business 2015 and as a last step trying to move the CMS database from Lync server 2010 to skype for business 2015.
As mentioned in( https://docs.microsoft.com/en-us/lyncserver/move-the-lync-server-2010-central-management-server-to-lync-server-2013 ) for CMS migration, first to install the CMS database on the skype for business 2015 FE server but while trying the (Install-CsDatabase -CentralManagementDatabase -SQLServerFQDN C01ict-SFBdb.abc.domain.com -SQLInstanceName RTC) command, getting the below error.
Now if we look into the error, it is mention that (Install-CsDatabase : Failed to connect to the SQL server C01ict-SFBdb.abc.domain.com\RTC) means unable to connect to the RTC instance. and yes the RTC instance was not in the SQL server, so we have to create the RTC instance in SQL server or have to use the install-csdatabase command without the -SQLInstanceName switch, which is an easy way. so the required database will be created in the default install of SQL server. so we change the command to (Install-CsDatabase -CentralManagementDatabase -SQLServerFQDN C01ict-SFBdb.abc.domain.com) and the below error was gone. the LIS and XDS databases were created within SQL default instance. and the issue was resolved.


Error:
Loading Modules for Skype for Business Server 2015...
PS C:\Users\User> Install-CsDatabase -CentralManagementDatabase -SQLServerFQDN C01ict-SFBdb.abc.domain.com -SQLInstance
Name RTC
****Creating DbSetupInstance for 'Microsoft.Rtc.Common.Data.XdsDatabase'****
Trying to connect to Sql Server C01ict-SFBdb.abc.domain.com\RTC. using windows authentication...
Exception Stack:
Type: System.Reflection.TargetInvocationException, Message: Exception has been thrown by the target of an invocation.
Type: Microsoft.Rtc.Common.Data.DbSetupSqlServiceNotInstalledException, Message: Failed to find SQL Service. Make sure t
hat SQL Server service (instance name RTC) is installed in machine C01ict-SFBdb.abc.domain.com
Install-CsDatabase : Failed to connect to the SQL server C01ict-SFBdb.abc.domain.com\RTC.
At line:1 char:1
+ Install-CsDatabase -CentralManagementDatabase -SQLServerFQDN C01ict-S ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:SourceCollection) [Install-CsDatabase], DbSetupSqlServiceNotInstalled
   Exception
    + FullyQualifiedErrorId : SqlConnectionFailure,Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet
****Creating DbSetupInstance for 'Microsoft.Rtc.Common.Data.LisDatabase'****
Trying to connect to Sql Server C01ict-SFBdb.abc.domain.com\RTC. using windows authentication...
Exception Stack:
Type: System.Reflection.TargetInvocationException, Message: Exception has been thrown by the target of an invocation.
Type: Microsoft.Rtc.Common.Data.DbSetupSqlServiceNotInstalledException, Message: Failed to find SQL Service. Make sure that SQL Server service (instance name RTC) is installed in machine C01ict-SFBdb.abc.domain.com
Install-CsDatabase : Failed to connect to the SQL server C01ict-SFBdb.abc.domain.com\RTC.
At line:1 char:1
+ Install-CsDatabase -CentralManagementDatabase -SQLServerFQDN C01ict-S ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:SourceCollection) [Install-CsDatabase], DbSetupSqlServiceNotInstalled
   Exception
    + FullyQualifiedErrorId : SqlConnectionFailure,Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet
WARNING: Install-CsDatabase failed.
WARNING: Detailed results can be found at
"C:\Users\User\AppData\Local\Temp\Install-CsDatabase-975ca94c-1c88-41bd-80e4-54e4265b8dc8.html".
PS C:\Users\User>

No comments:

Post a Comment