Tag Archives: microsoft

Changing the default locale for virtual machine templates in Virtual Machine Manager 2012 R2

Microsoft System Center Virtual Machine Manager 2012 R2 or 2012 SP1 does not allow you to set the locale via the user interface (gui). There are currently 2 workarounds for this. One uses powershell to alter the template itself. And one uses a unattended.xml which you add to the template using the user interface (gui).

The powershell method

1. Launch the VMM Console.
2. Click on the Settings option.
3. Click on PowerShell and execute the commands below on the respective Template.

$template = Get-SCVMtemplate | where {$_.Name  -eq "Template_Name"} 
$settings = $template.UnattendSettings;
$settings.add("oobeSystem/Microsoft-Windows-International-Core/UserLocale","cy-GB");
$settings.add("oobeSystem/Microsoft-Windows-International-Core/SystemLocale","cy-GB");
$settings.add("oobeSystem/Microsoft-Windows-International-Core/UILanguage","cy-GB");
$settings.add("oobeSystem/Microsoft-Windows-International-Core/InputLocale","0452:00000452");
Set-SCVMTemplate -VMTemplate $template -UnattendSettings $settings

NOTE: For the steps above, the regional settings (e.g. cy-GB) will vary based on the language being used. 

Look up the values you need from the two following locations

http://technet.microsoft.com/en-us/library/cc766503%28v=ws.10%29.aspx
http://technet.microsoft.com/en-us/library/cc766191%28v=ws.10%29.aspx

The unattended.xml method

Create an unattend.xml with the specific locale settings required. Below is a sample unattand.xml set to en-us but you can replace the en-us entries with the language code of your choice.

<?xml version="1.0" encoding="utf-8"?>
<unattend xmlns="urn:schemas-microsoft-com:unattend">
    <settings pass="oobeSystem">
        <component name="Microsoft-Windows-International-Core" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <InputLocale>en-us</InputLocale>
            <SystemLocale>en-us</SystemLocale>
            <UILanguage>en-us</UILanguage>
            <UILanguageFallback>en-us</UILanguageFallback>
            <UserLocale>en-us</UserLocale>
        </component>
    </settings>
    <cpi:offlineImage cpi:source="wim:c:/install.wim#Windows Server 2012 SERVERDATACENTER" xmlns:cpi="urn:schemas-microsoft-com:cpi" />
</unattend>

References

http://support.microsoft.com/kb/2709539

// CrashMAG

How to check for active trace flags on Microsoft SQL Server

You check for active trace flags by running the following query. They may be global or they may be session based.

Checking for active trace flags

DBCC TRACESTATUS

The output could be something like the following.

TraceFlag Status Global Session
--------- ------ ------ -------
4199      1      1      0
4616      1      1      0

(2 row(s) affected)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

If there are no active trace flags you will only see

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Enable session based trace flags

To enable trace flags only in your session use the following two commands.

DBCC TRACEON (trace#)
DBCC TRACEOFF (trace#)

trace#
Is the number of the trace flag to turn on.

Enable trace flags globally

DBCC TRACEON (trace#,-1)
DBCC TRACEOFF (trace#,-1)

-1
Switches on the specified trace flags globally.

To enable a trace flag to persist through a restart. Alter the “Startup Parameters” in the Advanced tab for the SQL Server service in SQL Server Configuration Manager.

One example would be.

Before modification

-dC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

After modification

-dC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf;-T4199

sqlservr [-sinstance_name] [-c] [-dmaster_path] [-f]
[-eerror_log_path] [-lmaster_log_path] [-m]
[-n] [-Ttrace#] [-v] [-x] [-gnumber] [-h]

References

DBCC TRACEON (Transact-SQL)
DBCC TRACEOFF (Transact-SQL)
DBCC TRACESTATUS (Transact-SQL)
Trace Flags (Transact-SQL)

// CrashMAG