Category: Tech

Ever deployed a non-English Windows server via SCVMM and then tried installing SQL server on it? Won’t work. The OS and SQL server languages have to match and in a stroke of genius SCVMM always make the base deployment for any new VM templates in English!!

What I’d imagine throws most people off is that the OS will display in the language locale you’d expect – Japanese in my case, but underneath the settings will be English. This can be verified by opening the command prompt. All errors will be in English and not the language the GUI is displayed in.

Error message:
“SQL Server setup media does not support the language of the OS or does not have ENU localized files. Use the matching language-specific SQL Server media or change the OS locale”

It’s easy enough to fix with an update to the SCMMM VM templates (use the updated template to re-deploy the server OS):

$template = Get-SCVMtemplate | where {$_.Name -eq "Win2012R2_JP_NEW_WG"}
$settings = $template.UnattendSettings;
$settings.add("oobeSystem/Microsoft-Windows-International-Core/UserLocale","ja-JP");
$settings.add("oobeSystem/Microsoft-Windows-International-Core/SystemLocale","ja-JP");
$settings.add("oobeSystem/Microsoft-Windows-International-Core/UILanguage","ja-JP");
$settings.add("oobeSystem/Microsoft-Windows-International-Core/InputLocale","1041:00000411");
Set-SCVMTemplate -VMTemplate $template -UnattendSettings $settings

The InputLocale values must match with “ja-JP” or whatever you wish to use. To get the values, please refer to:

Language Pack Default Values: http://technet.microsoft.com/en-us/library/cc766191(v=ws.10).aspx

Default Input Locales: http://technet.microsoft.com/en-us/library/cc766503(v=ws.10).aspx

apt-get install cifs-utils

sudo mount -t cifs //<server>/<share> /<mount point> -o username=<username>,domain=<domain>,password=<your password>

It’s fine to omit the password on the command line for security purposes. It will then prompt for it to be entered and it will remain hidden.

Global settings stored here:
vi /etc/profile

Add to the end:
MY_PROXY_URL=”http://proxyserver:portnumber/”
HTTP_PROXY=$MY_PROXY_URL
HTTPS_PROXY=$MY_PROXY_URL
FTP_PROXY=$MY_PROXY_URL
http_proxy=$MY_PROXY_URL
https_proxy=$MY_PROXY_URL
ftp_proxy=$MY_PROXY_URL
export HTTP_PROXY HTTPS_PROXY FTP_PROXY http_proxy https_proxy ftp_proxy

For example:
MY_PROXY_URL=”http://proxy.dsc.local:8080/”