Do you get the error: "You must provision the system with at least one system administrator" while installing SQL 2008 through command line?

  • Article

Issue Details

While installing SQL 2008 through command line, you may get this as the part of the error:

"You must provision the system with at least one system administrator"

I tried to find out the possible cause, but did not find any. Also I looked into this technet article: https://msdn.microsoft.com/en-us/library/ms144259.aspx [How to: Install SQL Server 2008 from the Command Prompt] but did not find any information regarding the issue.

What is the cause?

The main cause for the error message was missing of this parameter in the command line used: '/ASSysAdminAccounts'

If you add the parameter without any value, then you will get this error:

 [because this is what the above said article mentioned:

Analysis Services /ASSYSADMINACCOUNTS Required   Specifies the administrator credentials for Analysis Services.]

The following error occurred:
The element 'ASSysAdminAccounts' in namespace 'https://www.microsoft.com/sql/configuration/AS/Public/2007/04' has incomplete content. List of possible elements expected: 'Member' in namespace 'https://www.microsoft.com/sql/configuration/AS/Public/2007/04'.

How to resolve this error?

In order to resolve that error, provide an user name for /ASSYSADMINACCOUNTS parameter - for example:

/ASSYSADMINACCOUNTS="<Domain\username>

Given below a sample command line to install SQL engine, Analysis Services, Integration Services and Tools in quite mode:

Setup.exe /QS /ACTION=Install /FEATURES=SQL,AS,IS,Tools /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="<Domain\Username>" /SQLSVCPASSWORD="<password>" /SQLSYSADMINACCOUNTS="<Domain\Username>" /AGTSVCACCOUNT="<Domain\Username>" /AGTSVCPASSWORD="<password>" /ASSVCACCOUNT="<Domain\Username>" /ASSVCPASSWORD="<password>" /RSSVCACCOUNT="<Domain\Username>" /RSSVCPASSWORD="<password>" /ISSVCACCOUNT="<Domain\Username>" /ISSVCPASSWORD="<password>" /ASSYSADMINACCOUNTS="<Domain\Username>"

Hope this information is helpful.