One of my customers inadvertently removed a drive from the server, where all of the system databases log files were sitting. I am in the process of trying to rebuild the system databases first, so that I can restore them from backups. My statement is below. It fails every time with this error:
Exit message: The Windows account [/SAPWD=XXXXX] does not exist and cannot be provisioned as a SQL Server system administrator.
This is my statement -- I am running cmd prompt as administrator -
Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS = domainname\me [/SAPWD=XX]
BOL very clearly states this should be the password of the sa account -- which it is. The customer is certain it is, anyway. Are there any other ways around this? For example, can another admin account be used?
Very critical. Please advise.