SQLSYSADMINACCOUNTS syntax for multiple account usage during /Configurationfile based installation

_{Tuesday, September 2, 2008 8:47 PM}

For the SQL Server 2008/RTM version, I am looking for the correct syntax for the variable SQLSYSADMINACCOUNTS when specifying multiple accounts versus the standard single “Builtin\Administrator” account during a /ConfigurationFile parameter (INI based) unattended installation. BOL documentation appears to reference the ability to specify more than one account by virtue of the variable name which has an "S" at the end of SQLSYSADMINACCOUNTS, but there is no reference on the syntax for the delimiter (comma, semi-colon, etc) used between account values when creating the INI file, at least that I can locate. The following is a sample of what I am looking for:

SQLSYSADMINACCOUNTS=”<<MACHINENAME>>\Administrator, <<MACHINENAME>>\userx”

where, "Administrator" and "userx" would be the two accounts. A comma delimiter has been tried but does not appear to work, and separate entry lines for each (breaking the single line into 2 seprate lines for each user) end up with the last line being used as the account value.

Is this only available for single account rerfeence, and if not, is there syntax/documentation for the delimiter?

Mike

_{Wednesday, September 3, 2008 2:15 AM ✅Answered | 10 votes}

In order to specify multiple accounts for SQLSYSADMINACCOUNTS use a space as a delimiter. Ie:

SQLSYSADMINACCOUNTS="<<MACHINENAME>>\Administrator" "<<MACHINENAME>>\userx"