ADDCURRENTUSERASSQLADMIN parameter not working for SQL Server 2008 Express install as ClickOnce application Prerequisite.

dparden
dparden used Ask the Experts™
on
I am installing a ClickOnce application that has included SQL Server 2008 Express in the list of Prerequisites.  It installs SQL Server 2008 Express and my application but the Windows User does not have access to the server.  I have verified the C:\Program Files (x86)\Microsoft SDKs\ClickOnce Bootstrapper\Packages\SqlExpress2008R2\en\Package.XML and it has included the arguments list as shown below.

Arguments='/q /hideconsole /action=Install /ADDCURRENTUSERASSQLADMIN /features=SQL /instancename=SQLEXPRESS /enableranu=1 /sqlsvcaccount="NT Authority\Network Service" /AddCurrentUserAsSqlAdmin /IAcceptSqlServerLicenseTerms /skiprules=RebootRequiredCheck'
     
Any ideas on how to resolve this issue?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
>> /ADDCURRENTUSERASSQLADMIN /

In Arguments, Your parameter doesn't have the value passed out and hence it isn't recognizing that parameter, add = TRUE or FALSE to get the value passed for this parameter correctly.
/ADDCURRENTUSERASSQLADMIN = TRUE /

Since SQL Server 2008 MSDN pages are gone, I couldn't get the MSDN pages and hence refer this page for all possible parameters available for Silent installation.
http://geekswithblogs.net/Wchrabaszcz/archive/2012/12/12/sql-2008-express-silent-installation.aspx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial