Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Localisation and SQL 2012 deployment Expand / Collapse
Author
Message
Posted Tuesday, July 16, 2013 9:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 25, 2014 8:52 AM
Points: 243, Visits: 310
Hi guys,
we are deploying an application to several locations from the UK, one of these is Moscow.

The application is dependant on SQL express 2012, so as part of the installer we have a silent install of SQL 2012 using something like the following:
SQLEXPR32_x86_ENU.exe /qs /IACCEPTSQLSERVERLICENSETERMS /INSTANCENAME=xxxxxxx /SQLSYSADMINACCOUNTS=\"BUILTIN\\ADMINISTRATORS\" /ACTION=Install /FEATURES=SQLEngine /SECURITYMODE=SQL /SAPWD=xxxxxxxx";

When we installed the app locally, the sql install works perfectly, but when we install it in Moscow, it complains about BUILTIN\\ADMINISTRATORS as it not in Russian.

Has anyone dealt with language variants for security groups on the install?

Many thanks for any guidance!

Peter


I work for 1st Consulting, a small ISV based in the UK. We build web and desktop applications using the MSFT stack. Find us at www.1stconsulting.biz
Post #1474196
Posted Wednesday, July 17, 2013 6:40 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 2:27 PM
Points: 3,309, Visits: 6,702
Could it be that the BuildIn adminstrator account is disabled? If I am not mistaken, the buildin administrator account is disabled by default in Windows 7.

-Roy
Post #1474556
Posted Wednesday, July 17, 2013 6:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 25, 2014 8:52 AM
Points: 243, Visits: 310
Hi Roy,
Checked that and its not a problem.

For the time being (since this is invoked from the c#) I have got the builtin\administrator group via the SID
string myAdminAccount = new SecurityIdentifier("S-1-5-32-544").Translate(typeof(NTAccount)).ToString();

However, I am not sure how I would do this from within T-SQL?

Cheers

Peter


I work for 1st Consulting, a small ISV based in the UK. We build web and desktop applications using the MSFT stack. Find us at www.1stconsulting.biz
Post #1474571
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse