"You are not a recognized user of Microsoft Dynamics AX. Contact your system administrator for help".

i have restored a database from one environment to another environment. after that i am trying to open Ax showing a error ""You are not a recognized user of Microsoft Dynamics AX. Contact your system administrator for help".  "

solution:

http://blogs.msdn.com/b/axsupport/archive/2011/09/02/steps-to-restore-an-ax-database.aspx


find out SID:

go to run-->type regedit

 

software and hardware requirements for ax 2012

Network Requirements:
Microsoft Dynamics AX can operate on networks that use Internet Protocol Version 4 (IPv4) or
Internet Protocol Version 6 (IPv6).
network response time:
Client to AOS: 100 megabits per second (Mbps)
AOS to DataBase: 100Mbps

Domain requirements

1. Computers that run Microsoft Dynamics AX components must belong to an Active Directory domain,and Active Directory must be configured in native mode.
2.  Computers that run Microsoft Dynamics AX components must have access to other computers in Active Directory. These computers may be either in the same domain or in another trusted domain.
3. The domain controller must run in Windows 2008 mode or later.
4. To support e-mail alerts in Microsoft Dynamics AX, an SMTP (Simple Mail Transfer Protocol) server must be present in the environment.

Hardware Requirements:

Hardware that is required to install and run the AOS and the Microsoft Dynamics AX client.

Processor: Intel Pentium/Celeron family or compatible Pentium III Xeon or higher processor. We

recommend a processor speed of 1.1 GHz or higher.

RAM: 4 GB or more of RAM for server computers.

            2 GB or more of RAM for client computers.

Monitor: Super VGA (1024x768) or higher resolution monitor

Other: A DVD drive is required for an installation from a DVD.

S/W requirements for all computers:

The following software must be present on a computer before any Microsoft Dynamics AX components

can be installed:

• Microsoft .NET Framework : Most Microsoft Dynamics AX components, including the Setup wizard, require .NET Framework 3.5 with Service Pack 1.

For those components that require .NET Framework 4.0 or .NET Framework 4.5, it is listed as an

additional requirement in this document.

•  Microsoft Windows Installer 3.1 or Windows Installer 4.0

Supported server operating systems: 

The server operating systems that are supported for Microsoft Dynamics AX 2012 components.

Windows Server 2012 Standard Edition or Datacenter Edition

Windows Server 2012 is supported by default with Microsoft Dynamics AX 2012 R2. To use Windows Server 2012 with an earlier version of Microsoft Dynamics AX 2012, you must install cumulative update 5 for Microsoft Dynamics AX

(https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2828929)

Windows Server 2008 R2 Standard Edition,Enterprise Edition, Web Edition, or Datacenter

Edition

Windows Server 2008 Standard Edition, Enterprise Edition, Web Edition, or Datacenter Edition, with

Service Pack 2 (Only 64-bit versions of Windows Server 2008 are supported.)

Software requirements for server computers:

1. Databases
2. Application Object Server (AOS)
3. Enterprise Portal
4. Enterprise Search
5. Help Server
6. Microsoft SQL Server Reporting Services extensions
7. Microsoft SQL Server Analysis Services configuration
8. Web services on Internet Information Services (IIS)
9. Synchronization proxy for Microsoft Project
10. Synchronization service for Microsoft Project
11. Management utilities

Software requirements for database servers

Microsoft SQL Server 2012, Standard Edition, Enterprise Edition, or Business Intelligence Edition.

Service Pack 1 (http://www.microsoft.com/enus/download/details.aspx?id=35575) for Microsoft SQL Server 2012 is supported with the following updates:

 Cumulative update 1 for Microsoft Dynamics AX 2012 R2

(https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2807685)

 Cumulative update 5 for Microsoft Dynamics AX 2012

(https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2828929)

SQL Server 2008 R2, Standard Edition, Enterprise Edition, or Datacenter Edition.

Service Pack 1

(http://www.microsoft.com/download/en/details.aspx?id=26727) is supported, but it is not required unless you are installing Reporting Services extensions.

Service Pack 2

(http://www.microsoft.com/download/en/details.aspx?id=30437) is supported with cumulative update 4 for Microsoft Dynamics AX 2012

(https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2765124).

SQL Server 2008, Standard Edition or Enterprise Edition, with Service Pack 1.

Service Pack 3 is supported with cumulative update 4 for Microsoft Dynamics AX 2012.

Application Object Server (AOS)

 .NET Framework 4.5 is supported by default with Microsoft Dynamics AX 2012 R2, and with cumulative update 5 for Microsoft Dynamics AX 2012

(https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;ENUS;2828929)

–or–

.NET Framework 4.0, with the hotfix from Knowledge Base article 2390372

(http://support.microsoft.com/kb/2390372).

 SQL Server 2008 Native Client

Enterprise Portal

1 .Web server role

2. IIS 7.0, IIS 7.5, or IIS 8.0 (supported only with Microsoft Dynamics AX 2012 R2)

3. ASP.NET 2.0

4.Microsoft SharePoint Foundation 2013 (supported only with Microsoft Dynamics AX 2012 R2) 

   –or–

  Microsoft SharePoint Server 2013, Standard Edition or Enterprise Edition

  (recommended) (supported only with Microsoft Dynamics AX 2012 R2)

  –or–

 SharePoint Foundation 2010 

–or–

SharePoint Server 2010, Standard Edition or Enterprise Edition (recommended)

5. SQL Server 2008 R2 Analysis Management Objects (AMO)

Reporting Services extensions

1.Microsoft SQL Server Reporting Services 

To create a PowerView report that displays data from an analysis cube, you must use SQL Server 2012

Reporting Services with Service Pack 1 and cumulative update package 4

(http://support.microsoft.com/kb/2833645) or a later update for SQL Server 2012. Reporting Services

must be installed in SharePoint integrated mode.

 If you are using SQL Server 2008 Reporting Services, Service Pack 2

(http://www.microsoft.com/enus/download/details.aspx?id=12548) with cumulative update package 3

(http://support.microsoft.com/kb/2498535) or a later update for SQL Server 2012 is required.

2.Windows PowerShell 2.0

(http://support.microsoft.com/kb/968929)

Analysis Services integration

To create a PowerView report that displays data from an analysis cube,you must use SQL Server 2012

Analysis Services with Service Pack 1 and cumulative update package 4

(http://support.microsoft.com/kb/2833645) or a later update for SQL Server 2012.

 If you’re using SQL Server 2012 Analysis Services, you must install cumulative update package 1

(http://support.microsoft.com/kb/2679368) for SQL Server 2012.

 SQL Server Management Studio

 SQL Server Business Intelligence

Development Studio (BIDS) if you are using SQL Server 2008 or SQL Server 2008 R2

–or–

SQL Server Data Tools (SSDT) if you are using SQL Server 2012

Management utilities:

Windows PowerShell 2.0 (http://support.microsoft.com/kb/968929)

Software requirements for client computers

1. Windows client
2. Office Add-ins
3. Remote Desktop Services integration
4. Debugger
5. Microsoft Visual Studio Tools
6. Trace Parser
7. .NET Business Connector

Supported client operating systems

Windows 8, Windows 8 Pro, and 

Windows 8 Enterprise Edition

Windows 8 is supported by default with Microsoft Dynamics AX 2012 R2.

To use Windows 8 with an earlier version of Microsoft Dynamics AX 2012, you must install cumulative update 5 for Microsoft Dynamics AX 2012

(https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;ENUS;2828929).

Both 32-bit and 64-bit versions of Windows 8 are supported

Windows 7 Professional Edition,Ultimate Edition, or Enterprise Edition

Both 32-bit and 64-bit versions of Windows 7 are supported.

Windows Vista Business Edition,Ultimate Edition, or Enterprise Edition, with Service Pack 2

Both 32-bit and 64-bit versions of Windows Vista are supported.

Software requirements for the Microsoft Dynamics AX client

1. .NET Framework 4.5 is supported with

Microsoft Dynamics AX 2012 R2, and with cumulative update 5 for Microsoft Dynamics AX 2012

(https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;ENUS;2828929)

–or–

.NET Framework 4.0

2. Internet Explorer 10.0

–or–

Internet Explorer 9.0

–or–

Internet Explorer 8.0

–or–

Mozilla Firefox 11.0 (supported only with Microsoft Dynamics AX 2012 R2)

–or–

Mozilla Firefox 3.5

–or–

Safari 5.1.2

3. Office 2013

 –or–

Office 365 

–or–

2010 Microsoft Office release

–or–

2007 Office release, Service Pack 3

4. SQL Server 2008 R2 Analysis Management Objects (AMO)
Components for Ax-2012

 

How to display a company logo in MorphX Report

Before going to display a company logo in report, we have to add a logo in company information form.

Basic>Setup>Company Information>company logo button

in report:

To use the image in a report, add a Bitmap control to the report Design.

Add a display method for this added Bitmap control

display Bitmap  companyLogo()

{

    CompanyInfo companyInfo = CompanyInfo::find();

    ;

    return CompanyImage::find(companyInfo.DataAreaId, companyInfo.TableId, companyInfo.RecId).Image;

}

additionally, to make sure that the logo appear correctly, follow these steps

1. for the report you want to display logo, create the companyLogo() method.

2. Add a new Bitmap field in the report, then click comapnyLogo in the Datamethod property.

3. for the Bitmap field control, click Yes in the ResizeBitmap property.

set based operations

insert_recordset: 
insert_recordset is a record set-based operator, which performs operations on multiple records at a time. However, it can fall back to record-by-record operations in many situations.
insert_recordset copies data from one or more tables directly into one resulting destination table on a single server trip.
Using insert_recordset is faster than using an array insert. However, array inserts are more flexible if you want to handle the data before you insert it.
Example:

insert_recordset myTable (myNum, mySum)
                 select myNum, sum(myValue)
                 from anotherTable
                 group by myNum
                 where myNum <= 100;

update_recordset: 

The X++ SQL statement update_recordset enables you to update multiple rows in a single trip to the server. 

This means that certain tasks may have improved performance by using the power of the SQL server.

update_recordset resembles delete_from in X++ and to UPDATE SET in SQL. It works on the database server-side on an SQL-style record set, instead of retrieving each record separately by fetching, changing, and updating.

AOT-->Tables-->SlaesTable-->Methods-->updateDeadlineOnline()

delete_from:

You can delete multiple records from a database table by using a delete_from statement.
This can be more efficient and faster than deleting one record at a time by using the xRecord.delete method in a loop.

If you have overridden the delete method, the system interprets the delete_from statement into code that calls the delete method one time for each row that is deleted.

AOT-->Tables-->SlaesTable-->Methods-->deleteAllLines

public static void deleteAllLines(SalesId _salesId)
{
    SalesLine   salesLine;
    ttsbegin;
    delete_from salesLine where salesLine.SalesId == _salesId;
    ttscommit;
}

infolog : Report is scaled XXX percent to fit to page in AX 2009

when i opening a report every time showing a infolog "ReportNmae - Report is scaled XXX percent to fit to page "

solution: report level in init method write below line code after super

             this.printJobSettings().suppressScalingMessage(true);

Types of DataSources

Types of DataSources in AOT:

A form data source supplies the data that appears on a form. 
To display data, you assign a data field from the form data source to a property of a control that appears on the form.

1. Table: 

A table is a business object in the Data Dictionary node of the AOT. A table is an object that contains data records for the system. In additionally, a table can define a table relation that enables you to look up data from a referenced table.

2. View:
A view is a business object in the Data Dictionary node of the AOT. A view is a stored query that retrieves a specified collection of data records and fields. The data in a view is retrieved when the view is accessed. 

How to use in form level:

AOT>DataDictionary>View>DirPartyView

AOT>Form>DirPartyTable

3. Query:

A query is a business object in the Queries node of the AOT. A query uses tables, maps, or views to retrieve a set of data fields. To use a query as a form data source, you use the Query property of the Data Sources node to specify the query for the form.

You might find that a query has set the Dynamic property of the Fields node to No. You set Dynamic to No when you want to specify the list of fields that appear in the query. When you add that query to the Data Sources of a form, the list of fields in the table node include all the fields for the table.

http://msdn.microsoft.com/en-us/library/bb278121.aspx

I am trying to install IIS showing a error message in internet explorer:

trying to install IIS showing a error message in internet explorer:

Solution:

Internet exploreràinternet optionsàadvanced tab pageà resetàreset.