UmeshPandit

========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ========== 
Rebuild All: 0 succeeded, 1 failed, 0 skipped but no item in error list
Rebuild All: 0 succeeded, 1 failed, 0 skipped error in Microsoft Dynamics 365 Finance and Operations

After 3 days of Debug we found that:

Before starting any development task in Branching and VSTS controlled environment we should follow these steps:
Full Get Latest,
full compile,
sync and 

UmeshPandit

Disabling multiple users in Dynamics 365 For Finance and Operations 

select *from USERINFO

update userinfo set [enable] = 0 where ID <> 'Admin'

update userinfo set [enable] = 1 where ID <> 'Admin'

UmeshPandit

While Exporting a database from Microsoft Dynamics 365 for Finance and Operations all users are disabled and Batch Jobs are Withhold

Please note that the list of Data Elements that aren't exported


All users are disabled expect the "Admin".
All batch jobs are set to a status of Withhold.
Email addresses in the LogisticsElectronicAddress table
Batch job history in the BatchJobHistory, BatchHistory, and BatchConstraintHistory tables
SMTP password in the SysEmailSMTPPassword table

UmeshPandit

How to update the Email of all users in AX 2012 to invalid in test environments 

Open SSMS:

update SYSUSERINFO Set EMAIL = 'invalid@email.com' where EMAIL != ''

UmeshPandit

How to disable customer experience improvement program dialog in AX 2012

Open SSMS>

update SysUserInfo
set SqmEnabled = 1 --1 = no
--2 = yes
where SqmEnabled = 0 --0 = prompt

UmeshPandit

Tables Names	            Comments
AIFWEBSITES	              AIF
BATCHSERVERCONFIG	        Batch
BATCHSERVERGROUP	        Batch
BIAnalysisServer	        SSAS
EPGLOBALPARAMETERS	      EP
EPWEBSITEPARAMETERS	      EP
LEDGERPARAMETERS          Management Reporter	MR
SRSSERVERS	              SSRS
SYSBCPROXYUSERACCOUNT	    BC

UmeshPandit

Job to enable all user in AX 2012 R3

UserInfo   Userinfo;
ttsbegin;
While select forupdate Userinfo where userinfo.enable == NoYes::No
{
            Userinfo.Enable = NoYes::Yes;
            Userinfo.update();
}
         ttscommit;

UmeshPandit

How to login SSMS as windows authentication (Domain User) on Non-Domain Computer connected to VPN:


Below command is for launching SSMS for SQL Server 2017 (with a default install location):

runas /netonly /user:domainname\username "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"

UmeshPandit

Open Target SSMS
New Query:
update userinfo set [enable] = 1 where ID <> 'guest'

UmeshPandit

Import bacpac files Azure DB to Normal DB SQL 
Download bacpac file in Dev Box
Backup Dev Box AXDB DB.
Open CMD as Admin

cd C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin
Run
SqlPackage.exe /a:import /sf:C:\Temp\UATbackup.bacpac /tsn:localhost /tdn:UATAxDB /p:CommandTimeout=4000