Re: SQLEXPR32.exe command line parameters.

Tech-Archive recommends: Speed Up your PC by fixing your registry

Greg,

Sorry, but I stepped outside of my comfort zone with these responses.
According to this article below,
"For SQL Server Express, the Local System Account is Network Service
Account."
http://download.microsoft.com/download/f/1/0/f10c4f60-630e-4153-bd53-c3010e4c513b/ReadmeSQLEXP2005.htm

Therefore, this should be "NT AUTHORITY\NetworkService"

Hope that it works,
RLF

<greg@xxxxxxxxxxxxxxxx> wrote in message
news:1194637257.490330.25830@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Still no luck - I get an error saying it "cant access the service
account - specify a domain user and password or use a built in system
account"

Here is the command line I am using - note I am doing it with mixed
mode (dont know if that is relevant):

sqlexpr32.exe -q /norebootchk /q reboot=ReallySuppress addlocal=all
SQLAUTOSTART=1 SQLACCOUNT="BuiltIn\System" INSTANCENAME="MYINST"
SAPWD="mypwd" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

I've also tried using SQLACCOUNT="NT AUTHORITY\System" with no luck.

Thanks,
Greg

On Nov 9, 11:52 am, "Russell Fields" <russellfie...@xxxxxxxxxx> wrote:
Greg,

I always install interactively, so I don't experience this. However, I
would expect it to be:
SQLACCOUNT="BuiltIn\System"

Try it and see if it works.

RLF

<g...@xxxxxxxxxxxxxxxx> wrote in message

news:1194624920.634961.184760@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



I've tried using the BuiltIn\System account but I got an error from
the Windows XP machine that to make sure the account exists - here is
the format I used : SQLACCOUNT=BuiltIn\System - does the user need to
be in quotes or brackets? Or is it something that needs configured on
the XP machine?

Thanks,
Greg

On Nov 9, 10:25 am, "Russell Fields" <russellfie...@xxxxxxxxxx> wrote:
Greg,

Mike Wachal (MSFT) is saying to set the SQLACCOUNT parameter to
Builtin\System.http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2230163&SiteID=1

The overall documentation is in the following link. It is generic to
all
SQL Server 2005 installations, so you need to only use options
supported
by
Express. (I assume that you already have seen this, but just in
case.)http://msdn2.microsoft.com/en-us/library/ms144259.aspx

RLF

<g...@xxxxxxxxxxxxxxxx> wrote in message

news:1194619581.564578.196880@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

What is the correct command line parameters to SQLEXPR32.exe that
will
default the Log On As: properties for the instance to use the
Built-in
account of Local System & Local Service?

I need it to be set to Local System immediately on install without
having to go into the configuration manager. When I run the
SQLEXPR32.exe right now I get the Network Service defaulted.

Thanks for any help,
Greg
g...@xxxxxxxxxxxxxxxxx Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -




.

Relevant Pages

  • Re: 18456 Login failed for user NT AUTHORITYSYSTEM
    ... No, not using fulltext Searching. ... problem and had ruled it out but had not though about tracing the account. ... > system and is unable to connect to SQL server. ... > SQLSERVERAGENT - but I'm sure it's not running under local system.) ...
    (microsoft.public.sqlserver.server)
  • Re: IMF fails to install
    ... Your Default Application Pool should be Network Service ... The Exchange Application Pool should be Predefined to Local System ... IISadmin is using local system account. ...
    (microsoft.public.exchange.misc)
  • Re: Local System Account & Network Access
    ... helpful and Roger's suggestion to use local service instead of local system ... account on a domain computer. ... membership but they do have a bearing on what a user/computer has access ... Logon ID: ...
    (microsoft.public.security)
  • RE: Get permission error after mdb move.
    ... You can give the Network Service account that Express is running under rights ... Check the security permissions that were granted to the folder on ... LocalService and Network Service are both low privilidged accounts. ... and attached to an instance of SQL Server 2005 ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Service Accounts Questions / Seeking Recommendations
    ... the account running the SQL Server Service can be Local System, ... Given then, that you run SQL Service as Local System (for example, a common ... > I'm only going to address the Service Broker issues (and some EXECUTE AS ...
    (microsoft.public.sqlserver.security)