The Hydration Wizard does not support disjoint namespaces. If you are planning to run the Hydration Wizard in a domain that uses a disjoint namespace you must use a workaround to get the SQL installation to work. More information about disjoint namespace can be found here:
During the SQL installation a system administration group is created and when this group should be referenced it can’t be found. The reason is that the Hydration Wizard uses the FQDN as the domain part when referencing the account. For example:
Disjoint namespace: js
The SQLSYSADMINACCOUNTS variable is set to the following “<FQDN>\<SQL_SYSADMGRP>”. This will give the following error in the SQL installation log:
SQLEngine: Engine : Failed to get account sid for account <FQDN>\<SQL_SYSADMGRP>. Exception is Microsoft.SqlServer.Configuration.Sco.ScoException: No mapping between account names and security IDs was done.
---> System.ComponentModel.Win32Exception: No mapping between account names and security IDs was done.
You have two possibilities to bypass this. One is the most obvious, and that is to install the SQL manually.
The other is to change the SQL installation script with the correct values. Here is how you do it:
- Open the file, \\<JS Share>\Applications\INSTALL – SQL 2012\INSTALL-SQL2012.wsf
- Update line 112 from:
oUtility.writeIni sIniFile, "OPTIONS", "SQLSYSADMINACCOUNTS", """" & oEnvironment.item("DOMAINADMINDOMAIN") & "\" & oEnvironment.item("SQL_SYSADMGRP") & """"
oUtility.writeIni sIniFile, "OPTIONS", "SQLSYSADMINACCOUNTS", """<Disjoint namespace>\" & oEnvironment.item("SQL_SYSADMGRP") & """"
- Save the file and start the Hydration Wizard and start your SQL installation.