Forum Discussion

Ralf Bopp's avatar
Ralf Bopp
Copper Contributor
Jul 31, 2025

Migration from 2015 to SFB 2019 with SQL FCI

Hi,

 

Customer have a 2015 setup with SQL Mirroring.

All working fine so far.

Now we Setup a WFCI  with CSV and an SQL FCI. The installation ran smooth and we can access the SQL FCI Name via SQL Management Studio.

Also test with port 1433 and 1434 are working. Permissions are checked and we have sa rights on the Databases.

After Setting up the 2019 environment in the Topology the Databases for the 2019 environment cannot be installed on the SQL FCI.

Always the same error, trying with Install-CSDatabse or with the TB.

User also have sa rights.

 

After 10minutes this error occured :

 

****Creating DbSetupInstance for 'Microsoft.Rtc.Common.Data.XdsDatabase'****
Initializing DbSetupBase
Parsing parameters...
Found Parameter: SqlServer Value cluster.lab.com.
Found Parameter: SqlFilePath Value C:\Program Files\Common Files\Skype for Business Server 2019\DbSetup.
Found Parameter: DatabaseType Value CentralMgmt.
Found Parameter: FeatureName Value CentralMgmtStore.
Found Parameter: DatabaseNames Value System.Collections.Generic.List`1[System.String].
Found Parameter: Publisheracct Value LWK\RTCUniversalServerAdmins.
Found Parameter: Replicatoracct Value LWK\RTCUniversalConfigReplicator.
Found Parameter: Consumeracct Value LWK\RTCUniversalReadOnlyAdmins.
Found Parameter: Role Value master.
Trying to connect to Sql Server cluster.lab.com. using windows authentication...
Sql version: Major: 16, Minor: 0, Build 1000.
Sql version is acceptable.
Validating parameters...
DbName xds validated.
SqlFilePath C:\Program Files\Common Files\Skype for Business Server 2019\DbSetup validated.
DbFileBase xds validated.
DbPath is not specified, using default.
Default DB Path is C:\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\.
DbPath C:\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\ validated.
Effective database Path: \\cluster.lab.com\C$\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\.
LogPath is not specified, using default.
Default Log Path is C:\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\.
LogPath C:\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\ validated.
Effective Log Path: \\cluster.lab.com\C$\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\.
Checking state for database xds.
Checking state for database xds.
Checking state for database xds.
State of database xds is detached.
Attaching database xds from Data Path \\cluster.lab.com\C$\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\, Log Path \\cluster.lab.com\C$\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\.
The operation failed because of missing file '\\cluster.lab.com\C$\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\xds.mdf'
Attaching database failed because one of the files not found. The database will be created.
State of database xds is DbState_DoesNotExist.
Creating database xds from scratch. Data File Path = C:\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\, Log File Path= C:\ClusterStorage\Volume1\MSSQL16.MSSQLSERVER\MSSQL\DATA\.
Clean installing database xds.
System.IO.IOException: The network name cannot be found.

   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, Object dirSecurityObj, Boolean checkHost)
   at System.IO.Directory.InternalCreateDirectoryHelper(String path, Boolean checkHost)
   at Microsoft.Rtc.Common.Data.DatabaseManager.CreateDatabase(String dbFileBase, String dbPath, String logPath, Int32 dbSizeMB, Int32 logSizeMB, Int32 dbGrowthMB, Int32 logGrowthMB, Int32 maxDbSizeMB, Int32 maxLogSizeMB)
   at Microsoft.Rtc.Common.Data.DatabaseManager.CleanInstallDatabase(String dbFileBase, String initialScripfilePath, String dbPath, String logPath, Int32 dbSizeMB, Int32 logSizeMB, Int32 dbGrowthMB, Int32 logGrowthMB, Int32 maxDbSizeMB, Int32 maxLogSizeMB)
   at Microsoft.Rtc.Common.Data.DbSetupBase.CleanInstallDatabase()
   at Microsoft.Rtc.Common.Data.DbSetupBase.CreateOrUpdateDatabase()
   at Microsoft.Rtc.Common.Data.XdsDatabase.CreateOrUpdateDatabase()
   at Microsoft.Rtc.Management.Deployment.Tasks.DatabaseCreator.CreateDatabaseForFeature(String featureName, Boolean clean, Boolean update, String sqlServer, String instanceName, String databaseType, List`1 databaseNames, Boolean collocated, Boolean backup, Boolean noreindex, DatabasePathAssignment[] pathAssignments, Boolean broadCast, String& logfile)

 

 

We tried nearly everything. But SQL FCI with Skype for Business seems not so common. 

 

Thank you for Help

 

Br.

 

Ralf

1 Reply

  • rbopp's avatar
    rbopp
    Copper Contributor

    Found the solution. A cluster shared volume ist not working with Skype for Business Database installation. I don´t know excatly why but in the guide only Active/Passive FCI is supported and it seems when activiating CSV its like an Active/Active. After i changed the CSV back to the "normal" Storage konfiguration it works directly.

Resources