Marc Lognoul's IT Infrastructure Blog

Cloudy with a Chance of On-Prem

Active Directory: ADMT Episode 3.1 – The Revenge of the SID’s

Leave a comment

SW EP3 Poster

Finally the new version of ADMT is out, together with the following tools and document, and downloadable from MS.com:

Sadly, it is not supported to deploy this version of ADTM on Read-only DC’s and on CORE version of Server 2008 or on any version prior Windows Server 2008. Apparently NT4 is not supported as source domain anymore and the migration agent is not supported on NT4 computers anymore…

Hopefully, it now uses SQL2005 as backend (remote or local) and comes with extended command-line capabilities for set-up and post set-up configuration

It’s therefore time to revise my backup/restore process a bit compared to by original post from April 08 (http://www.marc-antho-etc.net/blog/post/2008/04/BackupRestore-of-the-ADMT-Database.aspx)

Thanks to SQL2005 you can now backup to a remote folder, example:

“%PROGRAMFILES%Microsoft SQL Server90ToolsBinnosql.exe" -E -S %computername%MS_ADMT -Q"BACKUP DATABASE ADMT TO DI

SK = '\SERVERSHAREadmt.bak'"

Note that that the path contains 90 instead of 80 since the SQL version is incremented.

Now for another stuff, just a little bit tricky. It is possible to use ADMT against a remote SQL server. But the problem is: you have to create the database first and then install and configure ADMT while, to get your hands on the tool to create the database, you have to install ADMT first… Catch my drift?

Here is how to do it seamlessly:

  1. Log on you DC, preferably with a domain admin or with a user administrator on both DC and SQL Server
  2. Start the ADMT Setup
  3. On the Welcome screen, click Next
  4. On the EULA, select “I agree” then click Next
  5. On the customer Experience Improvement Program, chose whatever you want the click Next
  6. On the Database Selection, select “Use and existing SQL Server” and enter the name of the remote SQL then click Next
  7. The next screen will show an error messaging complaining about the fact that the setup could not connect to the remote SQL or find the ADMT database. Keep the wizard open and do not click on Finish
  8. Open a command-line and navigate to %WINDIR%ADMTAdmtDb 
  9. Execute the command “admtdb create /s:MYSQLSERVERMYINSTANCE” (the instance is optional and depends on your SQL configuration. The command should return “The ADMT database was created successfully”. If not, check permissions, connectivity, name resolution etc.
  10. Return to the Wizard and click Back
  11. On the Database Selection, select “Use and existing SQL Server” and enter the name of the remote SQL like you previously stated in the command-line then click Next
  12. The next screen should now show a successful message, click Finish

Now let’s say that you changed your mind and wish to use the local SQL Express that ADMT installed during the setup (yes it actually installed one instanced then disabled it). Here is how to do:

  1. Open a command-line and navigate to %windir%ADMTAdmtDb
  2. Execute the command “sc config MSSQL$MS_ADMT start= auto”, this will set the SQL instance’s startup mode to “Automatic”
  3. Execute the command “sc start MSSQL$MS_ADMT”. It should return a text containing “STATE              : 4  RUNNING”. This will start the SQL instance
  4. Execute the command “admtdb create /s:%computername%MS_ADMT” to create the ADMT database locally. It should return “The ADMT database was created successfully”
  5. Set the path to %windir%ADMT
  6. Execute the command “admt config setdatabase /s:%computername%MS_ADMT” to configure ADMT to use the local database. Note: The document from MS over ADMT v3.1 contains typos regarding the parameters of this command.
  7. Start the ADMT console to check if everything OK

And cut!

Advertisements

Author: Marc Lognoul

Relentless cloud professional. Restless rider. Happy husband. Proud father. Opinions are my own.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s