Install without setting ADDCURRENTUSERASSQLADMIN -
03-19-2010
, 02:58 PM
I would like to create a package to install SQL Server (Express) with adding
the current user as an administrator. The default package has the argument
/ADDCURRENTUSERASSQLADMIN and I have tried specifying
/ADDCURRENTUSERASSQLADMIN=false but I get an error in the logs saying
"Missing system administrator account. To continue, provide at least one
Windows account to provision as a SQL Server system administrator." If i
leave /ADDCURRENTUSERASSQLADMIN (not set to any value) then the install
completes OK.
I have specified /SECURITYMODE=SQL and /SAPWD="****" but I stil get the
above error. Surely, if I have specified mixed mode authentication and an sa
password I should not need to have a windows account as admin.
Unfortunately, the main documentation that I have found for the command line
arguments:
http://msdn.microsoft.com/en-us/library/ms144259.aspx
does not even mention ADDCURRENTUSERASSQLADMIN so I don't know how to
inhibit it or under what conditions I can disable it.
It seems reasonable to me to be able to perform an install without setting
up the current user as admin but the results I have had seem to contradict
that.
Please, if anyone can help it would be greatly appreciated.
TIA.
J. |