How to determine name of NT AUTHORITY\SYSTEM on French system

Question

Hi there.  On some French systems, we can set the SQLAccount=AUTORITE NT\SYSTEM .  On others, this may not work and we have to use SQLAccount=AUTORITE NT\système .  How can I determine which expression has to be used on a given system?  Thanks!

Answer 1

Hello,

My suggestion is to always install SQL Server setting the parameter for the service accounts to use “AUTORITE NT\Système”. It will work on all systems.

Try installing SQL Server from the Command Prompt and setting the parameter.

http://msdn.microsoft.com/en-us/library/ms144259.aspx#Accounts

Hope this helps.   
 
Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Alberto,

Thanks, I'll go with your suggestion.  What bugs me is that none of the Microsoft documentation which is available online nor the SQL Server BO specify to use AUTORITE NT\Système .  Why would all the currently available documentation be wrong?

Thanks again Alberto!

Answer 3

Hello,

Please let me know if that works on all platforms. I have seen on the Web, confirmation that AUTORITE NT\Système works on French systems using Windows XP, Windows Vista, Windows 7, Windows Server 2003 and Windows Server 208.

We will find a way to change the documentation. You can add community content online to TechNet and MSDN documentation.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 4

Alberto,

Thanks, I'll go with your suggestion.  What bugs me is that none of the Microsoft documentation which is available online nor the SQL Server BO specify to use AUTORITE NT\Système .  Why would all the currently available documentation be wrong?

Thanks again Alberto!

Its NOT recomended to use local system for SQL server or the sql agent service [SQL 2008 BPA has a rule for this]. You should use a low priviledge domain account for sql services. Does that explains the documentation?

---

Thanks - Vijay Sirohi

Answer 5

Thank you Vijay!

Answer 6

We have a install program that executes the install program for SQL Server Express 2005. We execute the install program using a INI file the contents of which are below:

[Options]
ADDLOCAL=SQL_Engine,SQL_Data_Files,Connectivity
INSTANCENAME=UPSBAT
SQLACCOUNT=AUTORITE NT\SYSTEM
SQLAUTOSTART=1
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
SAPWD="********"

We support multiple langages so this install program needs to work in a variety of languages and Operating systems.  We have found that the account name NT Autority for some languages French for example is translated into the local language. We also found that for French is is different for XP and Windows 7.

Should we be using some other account this is a install program we can't create a account we need to use what is available. Why is none of this documented it would be helpfull if there was one place to go to find all the local translations of NT Authority if we need to use that account.  

 

 

 

 

---

Developer

Answer 7

What we've done is use AUTORITE NT\SYSTEM on XP and W2003 and AUTORITE NT\Système on Vista, W7 and W2008 for French systems.  You need a different script for each system language.  You can review this link which deals with SQL Server 2008 R2 but the information regarding localized service names at the end of the document provides some information regarding the settings for other languages.

Hope this helps.

Answer 8

We are using Wise for Windows Installation Studio so in the setup file for French we now look at the Version of Windows we are dealing with, for XP we are using the SQLACCOUNT=AUTORITE NT\SYSTEM greater than XP SQLACCOUNT=AUTORITE NT\Système I just changed that yesterday based on the information in this thread.

You mention some link that has additional information on this?

 

 

 

---

Developer