ADMT "cannot open database 'ADMT' requested by the login"

 ADMT移轉流程

1.舊網域 條件轉寄站設定將新網域查詢轉寄新網域
2.舊新網域建立樹系信任
3.在新網域AD安裝ADMT套件及SQL

但是ADMT出現找不到 "cannot open database 'ADMT' requested by the login"
因其必須在AD使用者及電腦建立連接SQL帳號

4.最後ADMT物件移轉  使用者或電腦等物件

參考文章
https://support.microsoft.com/zh-tw/kb/2266373

Workaround 1:
The standard practice is to install ADMT on a member computer in the target domain. Install SQL Express 2008 SP1 on a Windows 2008 R2 member server in the target domain and then install ADMT 3.2 on that same member server.

Workaround 2:
If you have a requirement to install ADMT 3.2 on a domain controller in order to use command-line or scripted user migrations with SID History, install SQL 2008 SP1 (non-Express edition) on a Windows Server 2008 R2 member server in the target domain and select that remote instance when installing ADMT 3.2 on the domain controller. Alternatively, you can install SQL Express 2005 SP3 on the domain controller.

Workaround 3:
If you have a requirement to install ADMT 3.2 and SQL Express 2008 SP1 on the same domain controller, use the following steps on the target domain's domain controller:
Install the Cumulative Update Package 4 for SQL Server 2008 on the domain controller.

963036 Cumulative update package 4 for SQL Server 2008.

Install SQL Express 2008 SP1 on the domain controller. Note the SQL instance name created during the install (default is SQLEXPRESS).

Microsoft® SQL Server® 2008 Express Edition Service Pack 1
http://www.microsoft.com/downloads/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff&displaylang=en

Create a domain local group with the format of "SQLServerMSSQLUserlt;DCComputerName>lt;InstanceName>". For example, if the domain controller is named "DC1" and the SQL instance was "SQLEXPRESS" you would run the following command in an elevated command prompt:

NET LOCALGROUP SQLServerMSSQLUser$DC1$SQLEXPRESS /ADD


Retrieve the SQL service SID 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 elevated command prompt and note the returned SERVICE SID value:

SC SHOWSID MSSQL$SQLEXPRESS

In the Windows directory, create the "ADMT" subfolder and a subfolder beneath that named "Data". For example, you would run the following command in an elevated command 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 elevated command prompt:

ICACLS %systemroot%\ADMT\Data /grant *S-1-5-80-3880006512-4290199581-3569869737-363123133:F

Install ADMT 3.2 on the domain controller while selecting the local SQL Express 2008 instance.