Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Localisation and SQL 2012 deployment


Localisation and SQL 2012 deployment

Author
Message
Peter Bannister
Peter Bannister
SSC Veteran
SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)

Group: General Forum Members
Points: 243 Visits: 325
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
Roy Ernest
Roy Ernest
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2496 Visits: 6853
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
Peter Bannister
Peter Bannister
SSC Veteran
SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)SSC Veteran (243 reputation)

Group: General Forum Members
Points: 243 Visits: 325
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search