same DC, use the following steps on target domain DC:
- Install Cumulative Update Package 4 for SQL
Server 2008 on the DC - http://support.microsoft.com/kb/963036.
- Install SQL Express 2008 SP1 on the DC -
http://www.microsoft.com/downloads/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff&displaylang=en.
Note the SQL Instance name created during the install (default is SQLEXPRESS).
- Create a domain local group with the format of
"SQLServerMSSQLUser$<DCComputerName>$<InstanceName>". For example, if the DC is named "DC1" and the SQL instance was "SQLEXPRESS"
you would run the following command in an admin-elevated CMD prompt:
NET LOCALGROUP SQLServerMSSQLUser$DC1$SQLEXPRESS /ADD - Retrieve the SQL service SID by using the SC.EXE command with the name of
the SQL service instance. For example, if the SQL instance was "SQLEXPRESS" you
would run the following command in an admin-elevated CMD prompt and note the
returned SERVICE SID value:
SC SHOWSID
MSSQL$SQLEXPRESS
- In the Windows directory, create the "ADMT" subfolderfolder and a further
subfolder of "Data". For example you would run the following command in an
admin-elevated CMD prompt:
MD
%SystemRoot%\ADMT\Data - Using the SID retrieved in Step 4, set FULL CONTROL permissions on the
%SystemRoot%\ADMT\Data folder. For example, if the SID returned in Step 4 was
"S-1-5-80-3880006512-4290199581-3569869737-363123133" you would run the
following command in an admin-elevated CMD prompt:
ICACLS %systemroot%\ADMT\Data /grant *S-1-5-80-3880006512-4290199581-3569869737-363123133:F
- Install ADMT 3.2 on the DC while selecting the local SQL Express 2008
instance.
Aucun commentaire:
Enregistrer un commentaire