Localisation and SQL 2012 deployment

  • 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

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply