Step by step procedure for the Installation of AX2012R3 with screen shots(Part-1)

First, go through the prepequisites to install AX 2012R3
https://www.microsoft.com/en-in/download/details.aspx?id=11094

Cannot connect to database master at SQL server at sharepoint

If you encounter this error when installing sharepoint



1. goto sql server configuration manager > sql server network configuration > protocols for MSSQLSERVER> TCP/IP:enabled.


For more information go through
https://letitknow.wordpress.com/2013/04/04/cannot-connect-to-database-master-at-sql-server-checklist/

The aos 'name@2712' cannot be reached

1.While installing BI components, I got below error.. 

Solution:

Check System Admin > Setup > System Accounts. 
There check the login account mapped correctly.

Note:Before that make sure that AOS is running.

Failed to log on to Microsoft Dynamics

1.When I open the AX, got below warning..(Note: AOS services started)

Solution:

Step 1: Run CMD as  administrator and type whoami /all | more, it will display your name and the SID. Copy out the SID.

Step 2: Navigate to MSSQL Management Studio , locate the baseline database for AX and look for table called "dbo.userinfo", update the table with the necessary infos including the sid  or you can use the query below, modify to suit your needs.

update userinfo set

networkdomain = 'DomainName',

networkalias = 'NetworkAlias',

name = 'sam',

SID = 'S-1-5-21-XXXXXXXX-3956443045-XXXXXX-1001'

where ID = 'Admin'.

I had this issue and was able to resolve it after going through some processes.

(https://community.dynamics.com/ax/f/33/t/124554)

If the query is not executes. 

Sql-->Databases-->MicrosoftDynamicsAX-->Tables-->dbo.Userinfo, right click edit top 200 rows.

Replace the SID number of login account of AX in this table field(SID) with SID which gets in Step1.

                                                                                                                                                   

Lookup method at form level

1. Writing lookup method for a field at datasource level

2. Written code

public void lookup(FormControl _formControl, str _filterStr)
{
 
    SysTableLookup          sysTableLookup;
    ;

    //Create an instance of SysTableLookup with the form control passed in
    sysTableLookup = SysTableLookup::newParameters(tablenum(DAPInsuranceLevels),          _formControl);

    //Add the fields to be shown in the lookup form
    sysTableLookup.addLookupfield(fieldnum(DAPInsuranceLevels, levelid), true);
    sysTableLookup.addLookupfield(fieldnum(DAPInsuranceLevels, Description), true);


    // Perform lookup
    sysTableLookup.performFormLookup();
}

3. Output at form level