All geek questions in one place

What value should I use for the SQLSVCACCOUNT parameter when installing SQL Server Express 2008 R2 from the command line using SQLEXPRWT_x86_ENU.exe?

I use the following command to install SQL Server Express 2008 R2 on various operating systems (Windows XP. Server 2003, Server 2008, Server 2008 R2 and 7), but I'm not sure which account to use (and why) for the SQLSVCACCOUNT parameter. This installation of SQL Server will be part of a web application running on the same computer, and all of this will be installed using an NSIS script.

SQLEXPRWT_x86_ENU.exe /Q /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /ROLE=AllFeatures_WithDefaults /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /INSTANCENAME=SQLEXPRESS /SecurityMode=SQL /SAPWD="xxxxxxx"

Will the "NT \ Network Service" work for all operating systems on my list? Or maybe I should use a different account at all?

+6
source share
2 answers

A network service is the way to go on all operating systems; the local system provides higher privileges than you might need.

+6
source

The above is true, but if you are installing a Small Business Server or a server acting as a domain controller, you may get this error:

 Exit code (Decimal): -2068578304 Exit facility code: 1204 Exit error code: 0 Exit message: Network Service or Local Service account is not permitted for the SQL Server service on a domain controller. Specify a different account.

In these circumstances, you need to specify specific accounts.

+2
source

Source: https://habr.com/ru/post/925325/

More articles:


All Articles