Thursday, January 28, 2010

Forcing the regional settings via Group Policy using custom templates

Forcing the settings via Group Policy using custom templates
---------------------
You may want to read up on Group Policy if you're not familiar with it first.
Download and a regional setting .adm file (settings below) into C:\WINDOWS\INF on the domain controller. From Active Directory Users and Computers create a new container and place the users to wish to be affected into that container. Create a new group policy, attach it to the container and edit the settings. Note: This is a user configured policy and not a computer policy and will affect all users that are listed in the container that you attach it too.
Click on Administrative Templates underneath User Configuration and select Add/Remove Templates. Browse for the File->Open, and select C:\WINDOWS\INF\RegionalSettings.adm. Close the Add/Remove Templates window. From the group policy window select View->Filtering and untick Only show configured policy settings and Only show policy settings that can be fully managed, select OK. Under User Configuration->Administrative Templates->Control Panel->International Settings you should see 4 policies to set regional settings. Enable UK International Settings.
RegionalSettings.adm contents....
CLASS USER
; created by chriske911 on behalf of..

CATEGORY "Control Panel"
CATEGORY "International Settings"
KEYNAME "Control Panel"
POLICY "USA International Settings"
KEYNAME "Control Panel\International"
EXPLAIN !!USA_regopt
VALUENAME "sCountry"
VALUEON "USA"
ACTIONLISTON
KEYNAME "Control Panel\International"
VALUENAME "iCountry"
VALUE "1"
VALUENAME "iCurrDigits"
VALUE "2"
VALUENAME "iCurrency"
VALUE "2"
VALUENAME "iDate"
VALUE "0"
VALUENAME "iDigits"
VALUE "2"
VALUENAME "iLZero"
VALUE "0"
VALUENAME "iMeasure"
VALUE "0"
VALUENAME "iNegCurr"
VALUE "12"
VALUENAME "iTime"
VALUE "1"
VALUENAME "iTLZero"
VALUE "1"
VALUENAME "Locale"
VALUE "00000409"
VALUENAME "s1159"
VALUE ""
VALUENAME "s2359"
VALUE ""
VALUENAME "sCurrency"
VALUE "$"
VALUENAME "sDate"
VALUE "/"
VALUENAME "sDecimal"
VALUE "."
VALUENAME "sLanguage"
VALUE "ENU"
VALUENAME "sList"
VALUE ","
VALUENAME "sLongDate"
VALUE "dddd, MMMM dd, yyyy"
VALUENAME "sShortDate"
VALUE "M/d/yyyy"
VALUENAME "sThousand"

Sybase - Restoring Master Dump Process

Restoring a master dump file into a blank Sybase set-up.

Install Sybase.
Stop services.

Rename your current D:\Sybase\Data\master.dat to .old.

Change to D:\Sybase\ASE-12_5\bin in CMD

Create an empty master db by typing sqlsrvr -d d:\Sybase\Data\master.dat -z 2k -b 40960 this will create a master device which is 80MB in size.

Then make a copy RUN_SQLBOX.bat and called it something like MasterRecover.bat. Run it. This will leave a batch file version of the Sybase service running. Don't close it.

Load up another CMD window and connect using isql. The SA password will be blank at this point.

You need to set the master DB to use more of the master device in order to load the dump. Type

alter database master
on default "60M"
go

You then need to change the Sybase backup server name. Type:

update sysservers
set srvnetname = "SQLBOX_BS" (or whatever the backup servname should be)
where srvname ="SYB_BACKUP"
go

Start the Sybase backup service in services.msc. You can then load your database by typing

load database master from "D:\locationoffile.dat"
go

The master recover CMD window will now have closed and you then start the normal Sybase server service and connect using advantage or SQL Central Server etc... Note the sa password will be whatever it was in the database you have restored

Adding Windows 2008 DC's to Existing Domain

Adding Windows 2008 Domain Controllers

----------------------------------------------------------------
· You will need the Windows 2008 CD.

· In order to Add 2008 DC’s, the domain functional level needs to be at least Windows 2000 native.

· Check the forest/domain level. If you’re domain is not the root domain in the forest, you may not have sufficient rights to update the forest schema.

· You will need to create or use an existing user account which is a member of the following security groups.

Enterprise Admins

Schema Admins

Domain Admins for the domain that contains the schema master.

· Log onto the Schema Master DC as a user with the rights specified above. To check the Schema Master role you’ll need to load a DLL by running regsvr32 schmmgmt.dll from command prompt to enable the Schema snap-in. You can then go to Start-Run->Type MMC; select File-Add/Remove Snap In and select Active Directory Schema. One loaded, right click on Active Directory Schema and select Operations Master. The current Schema Master will be displayed.

· Go to command prompt and run... D:\sources\adprep\adprep /forestprep

Assuming D:\ is the CD drive.

If you have more than 1 domain controller, you should wait at least 15 minutes for the changes to replicate to other domain controllers

· From the Infrastructure Master DC, go to command prompt and run...D:\sources\adprep\adprep /domainprep /gpprep

Assuming D:\ is the CD drive.
Again if you have more than 1 domain controller, you should wait at least 15 minutes for the changes to replicate to other domain controllers.
To identify the domain Infrastructure Master, go to Active Directory Users and Computers, right-click the domain, click Operations Masters, and then click Infrastructure.

· Join the Windows 2008 server as a member server.

· Go to Start-Run-Type DCPROMO and run through the wizard.

-----------------

Transferring DC (FSMO) Roles

· Schema Master via Active Directory Schema

· Domain Naming Master via Active Directory Domains and Trusts

· RIS Master via Active Directory Users and Computers

· PDC Emulator via Active Directory Users and Computers

· Infrastructure Master via Active Directory Users and Computers