dbTalk Databases Forums  

Install without setting ADDCURRENTUSERASSQLADMIN

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Install without setting ADDCURRENTUSERASSQLADMIN in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jeremy Sage
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.