Microsoft Dynamics Axapta Technical,Functional Coverage

If you want to register new assembly by code in axapta then you can try following code in your programme. new SysReference(referenceName, assemblyName...).addToAOT();

There are two ways to improve performance of Import data through Excel template in axapta. Method one: You can Import the excel data into table in a dummy database of sql server or other dummy table in same database. Then you need to Create a odbc connection to the dummy database in the machine After that you need to Create a job in Axapta with odbc connectivity and pull the data by sql query. After reading the data then insert into respective tables of Axapta. You need to write database connectivity script. You can get that code on this blog too. Just use search box. Method two: Second method is you can use standard import functionality but  Don't use excel, you can use custom type importing option then convert your excel data into CSV format and define the table & columns and import the data.I am sure approx 20k records will be import few minutes.I hope This is the better way to import bulk records.

If you are facing performance issues in axapta then you can take following action. 1. Re-Indexing. 2. Create new indexes by getting hints from long query and select queries. 3. Check unwanted data in log tables and clear them if not required. 4. Increase RAM Size in sql database. 5. Check your disc where application and database installed. Required to check whether its free or not. 6. Check blocking processes from sql at working time. 7. Load balancing of AOS. I hope you get good hints from here for performance tuning.

This is probable details of Breakdown of the Microsoft Dynamics customer numbers by product. Microsoft Dynamics® CRM 39,000 companies with 3 million users  Microsoft Dynamics® AX 18,000 companies  Microsoft Dynamics® GP 43,000 companies  Microsoft Dynamics® NAV 94,000 companies  Microsoft Dynamics® SL 13,500 companies Currently CRM,AX,GP,NAV and SL are famous product of Micrsoft dynamics ERP.

How to change an Sales order from status Delivered to open order in ax 2009? In the receive now enter negative quantity and post the packing slip by selecting option receive now before posting, that's for reversing the quantity posted and making it an open order again. Edit the quantity in the order lines of already existing / posted line and the order changes to open order or create a new line in the existing order the order changes to open order. The sales order will be received if all the lines are received. If one or more lines is open the whole service order will be open.

If you are having buffer size issue while adding more fields in SalesTable. I thought to create a parallel table with SalesTable which could be used in future customization  and would associate this table on SalesTable form using SalesId relation on this new table with SalesTable. It works but only when You create new records in salesTable due to the relation defined between SalesTable and newly created table. However, it is not working with existing sales orders as there is not associated SalesId (from sales table) in newly created table. If You will go with this approach You have to run a job to update all SalesId from SalesTable to newly created table for existing records. These are other workaround rather than adding a new table or have ever come across with such requirement? 1) Insert Old Data from Orignal_SalesTable to New_SalesTable 2) Under Orignal_SalesTable, create(if not available)/see(if already) three methods, AosValidateInsert,AosValidateDelete,AOSValidateUpdate; These

Problem: Is there a way (configuration, add on or something else) to define the item coverage minimum in days instead of quantity? For example, if in the last 30 days I had 3000 Pcs in sales of an item, that means that my average sales is 100 Pcs per day. If I have now 400 Pcs on hand, that means I have 4 inventory days. Then if I could set the minimum inventory as, let say 6 days, that should mean for AX a shortage of 2 inventory days (200 Pcs that I need to purchase, therefore a planned order should be generated by master planning). Solution: The core of your requirement is not the Item coverage, what you need is to auto-generate the sales forecast based on historical sales data. Then you can use the standard functionality of item coverage code Period and define the period as your forecast bucket. In that case you make the sure that the item requirement will collect whatever in the sales forecast. I think it could work fine: The calculated forecast will need to be created in a

If you have created a General Journal for a fixed asset and while posting the journal you are getting following error “You must set up periods for the fixed asset calendar Calendar.” Than you can try following You can try to give that setup in GL > Setup > Fiscal Calendar if It did not contains periods. If It was originating due to wrong value assigned to Depreciation field in Depreciation profiles then this should be same as setup for Calendar value for value model associated with fixed asset.

If you want to Save value to Session view Variable in axapta Enterprise portal webform to use on other webform you can try below code declare variable and define macro variable. #define.TestType('TestSeq') TestType _TestSeq; //Then define loadviewstate method to load value to variable. public void loadViewState() { super(); if (this.viewStateContains(#_TestSeq)) _TestSeq= this.viewStateItem(#_TestSeq); } //Then define saveviewstate method to save value to variable. public void saveViewState() { ContainerClass cc; ; if (_TestSeq) this.viewStateItem(#_TestSeq, _TestSeq); super(); } Then you can store value to _TestSeq variable. Now you can use this variable value to running on other webform.

If anyone running his business and his business is running on different branches then you may require ERP package to maintain your company daily transactional data like finance,trading operations,material handling,BOM type items. I think first you will think to buy Tally Package to maintain your finance data but due to some restriction you will go for some database type ERP package which can be easy to migrate with other package also. I will suggest Axapta is very good tools of ERP . Its cost is not much high it will cost you 1.5 lac to 2 lacs Rs. per user but Enterprise portal license is very cheap. If you able to do best customization in EP then its going to very cheap but you will be restricted in EP so you should buy at least 10 application user license. You can get lot of reports, modules like Sales,Purchase,production,HRM etc. Its very much user friendly. You can easy move to all master form by using column value like go to main table on right click which is monopoly of

1. Other than the Reports folder, from where can the BOM calculation report be run? ANSWER - The BOM calculation report can also be run from the Item price form, by clicking Print. 2. Does circularity have to be a part of the BOM check process? How is this kind of check set up? ANSWER - No, circularity does not have to be part of the BOM check process. This check is automatically set up in the Inventory parameters form or when the Check circularity check box is selected in the Check BOM form. 3. What does the Append option in the Update lines field indicate in the Change BOM item form, and what is required when this option is selected? ANSWER - The item is replaced on a specific date and the chang is tracked, and both date fields must be filled in when the Append option is selected. 4. Which of the following is not included in the BOM line sorting option?(Select all that apply.) ( ) Line type ( ) Position (√) Item name ( ) Operation number 5. Which of the following reports is used to d

1. At a minimum, what information must be specified to report a BOM as finished? ANSWER - - Date for reporting-as-finished - Item number and any existing configuration - BOM number - Quantity to be reported as finished 2. Explain the purpose of the Max. report as finished form. ANSWER - This form is used to inquire how much of a BOM can be completed based on the available on-hand inventory. 3. What is the difference between running the Report as finished periodic job process and the report as finished process from the Item form? ANSWER - The periodic job is used to report multiple BOMs as finished. Only an individual item can be reported as finished from the Item form. 4. What is the purpose of reporting a BOM as finished? ANSWER - To reduce on-hand quantity for component items and increase on-hand quantity for the parent item based on the BOM setup. 5. In Microsoft Dynamics AX 2009 the Report as finished form cannot be accessed from which of the following? ( ) Periodic folder ( ) BOM

1. List the four rounding-up options. MODEL ANSWER - No., Quantity, Measurement, and Consumption 2. When is scrap specified? MODEL ANSWER - When the consumption of the raw materials used in the components of a BOM are calculated. 3. When are measurement configurations used? ANSWER - When calculating the consumption of the raw materials on each BOM line. 4. What measurement formula is used when consumption is not proportional to any dimensions of the finished item? ANSWER - Standard 5. Where can a user view how the cost price of an item with scrap has increased after calculation? ANSWER - In the Total cost price per unit field in the Complete BOM calculation form. 6. What is the difference between constant and variable scrap? ANSWER - Constant scrap is specified when the constant value is to be calculated only one time on the BOM line, regardless of how many items are produced. Variable scrap is a percentage value and is calculated as a percentage of the BOM line. 7. What are conversion

1. Where are parameters set for how components are displayed in the Composed of - tree form? ANSWER - On the Setup tab in the Composed of – tree form 2. Can new configurations be added to a configurable item during the sales order process? If configurations can be added, what are the rules? ANSWER - Yes, a new configuration can be added during the sales order process, as long as the configuration rules do not prevent the configuration combination. 3. What four values can be transferred to a sales order line after the BOM calculation is run? ANSWER - Price, Quantity, Sub-BOM, and Subroute 4. What is the purpose of exploding a BOM on a sales order? ANSWER - –To display all BOM components on the sales order and the related documents, such as the packing slip or the invoice. –To verify when orders can be delivered to the client, based on the purchasing or production of components. 5. In the Sales order form, the configuration for a BOM item is specified on the? ( ) General tab ( ) Setup ta

1. What is the difference between opening the BOM calculation form from the Item form or the Periodic folder? ANSWER - The Item form runs the calculation for the selected item. Calculation for all BOM items can be run from the Periodic folder. 2. Regarding the Summary and Complete functions in the Item price form, what is the difference between the displayed content? ANSWER - The Summary function displays a summary of the price calculations by cost group for each BOM level. The Complete function displays the calculations for each BOM component line. 3. What function omits a BOM item from calculation? ANSWER - Selecting the Stop explosion check box in the Item form. 4. Where is the default Calculation group set up in Microsoft Dynamics AX 2009? ANSWER - In the Inventory parameters form 5. What does a BOM structure show? ANSWER - –How a single item or operation contributes to the price of its BOM level. –How much all items and operations on a particular level contribute to the overall pr

1. Which application element is used to define to which module a workflow is applicable? ( ) Workflow template (•) Workflow category ( ) A field in the workflow configuration ( ) SalesTable 2. Which type of AOT element needs to be created to specify which tables will be affected by a workflow? ( ) Extended data type ( ) Class ( ) Form (•) Query 3. There are three types of providers that define what rules the workflow can follow. What are they? (√) Participant provider (√) DueDate provider (√) Hierarchy provider ( ) Internet provider 4. Which two properties on a form data source need to be modified to allow the form to use a workflow? ( ) WorkflowTemplate (√) WorkflowEnabled ( ) WorkflowDocument (√) WorkflowDatasource

1. True or False: A project is linked to the customer table through ProjTable.CustAccount. ANSWER: False 2. In which class would you find a method that returns whether an employee hours transaction has already been invoiced? ANSWER: ProjTransEmplTrans 3. When posting a project invoice, which method calls the project totals calculation method - projProposalTotals.calc()? ANSWER: CreateJournal

1. Which parm table is used when updating the status from Scheduled to Released? ANSWER: ProdParmRelease 2. Which class controls whether a production order can be updated from one status to another? ANSWER: ProdStatusType 3. WrkCtrRouteData is a data storage class which holds all____________ that are in a route. ANSWER: WrkCtrRouteData is a data storage class that holds all operations that are in a route.

1. Is the InventDimParm table a temporary table? ANSWER: Yes 2. In which method is an InventDim record created? ANSWER: InventDim::FindOrCreate() 3. Which class is used to create inventory transactions? ANSWER: InventUpdate 4. Why has the Inventory Multi-transaction Tracking system been introduced? ANSWER: To solve deadlocking in InventSum 5. True or false: An InventDimId is always unique to an itemId. ANSWER: False

1. True or False: SalesLineType is a sub-class of SalesTableType. ANSWER: False 2. In which method in SalesFormLetter are the records in SalesParmLine created? ANSWER: SalesFormLetter.CreateParmLine() 3. What is the name of the class used when posting vendor transactions that handle both posting to the AP sub-ledger and the AP ledger account? ANSWER: CustVendVoucher 4. What is 8 div 3? ANSWER: Two

1. Which class holds a list of transactions that are going to be posted for a particular voucher? ANSWER: LedgerVoucherObject 2. The transaction log type and transaction log text are used in the ________trail. ANSWER: The transaction log type and transaction log text are used in the audit trail. 3. Which table stores default values that initialize a LedgerJournalTablerecord? ANSWER: LedgerJournalName 4. Which class posts a journal? MODEL ANSWER: LedgerJournalCheckPost

1. How do you make CLR Interop assemblies visible to Microsoft Dynamics AX 2009 X++ code? ANSWER: You add references to the assembly files in the AOT, under the References node. 2. Are CLR Interop assemblies, classes, and methods case-sensitive when referenced in X++ code? ANSWER: Yes. They are case sensitive 3. What code do you use, to provide Code Access Security permission to a CLR Interop class? MODEL ANSWER: new InteropPermission(InteropKind) 4. Which node on the AOT are Web service references found? ANSWER: The References node. 5. Which class contains multiple methods, using the kernel32.dll and user32.dll objects to communicate with the Windows environment? ANSWER: WinAPI

1. Describe the purpose of the Business Connector. ANSWER: The Business Connector enables external applications to interact with Microsoft Dynamics AX 2009 Application Object Server instances. 2. Do you need to register the .NET connector into the Global Assembly Cache after it is installed? ANSWER: No. It is registered automatically during installation. 3. What is the Business Connector Proxy User account used for? ANSWER: It is used to enable the Business Connector to "act-onbehalf" of Microsoft Dynamics AX users who cannot be fully authenticated 4. How is debugging through the Business Connector enabled? ANSWER: Enable debugging on the AOS configuration, Enable debugging on the Client configuration, Set Debug mode to When Breakpoint, Open an instance of the Microsoft Dynamics AX debugger. 5. What is the purpose of the Managed Classes in the .NET Business Connector? ANSWER: They expose public methods that can be called to interact with Microsoft Dynamics

1. What is the syntax for setting the default printer option to e-mail in the PrintJobSetting class? ANSWER: PrintJobSettings.SetTarget(PrintMedium::Mail). 2. Which method would you use to initialize printJobSettings for a specificreport, when this report is called from a class? ANSWER: ReportRun.UnpackPrintJobSettings. 3. Where does Microsoft Dynamics AX store the previously selected printer settings for a specific report? ANSWER: Usage Data (SysLastValue).

1. When assigning numbers from the numberseq class, when would you use newGetNumAndVoucherFromCode() and newGetNumAndVoucher()? ANSWER: NewGetNumAndVoucher() is used to instantiate NumberSeq from NumberSeqReference. NewGetNumAndVoucherFromCode() is used to instantiate NumberSeq from a NumberSeqCode. 2. What does it mean that a number sequence is continuous? ANSWER: A continuous number sequence ensures that all numbers in the sequence are used. 3. From which method would you get the number sequence reference used for a sales order number? ANSWER: SalesParameters.NumRefSalesId().

1. Which kernel class is documenting the individual field in a data source and how do you get a handle to it? ANSWER - The kernel class FormDataObject documents fields on a data source. You can get a handle by using FormDataSource.Object(<fielded>)</fielded> 2. Which methods do you override if you want to make changes to the structure of the query which fetches data to the data source? ANSWER - You override FormDataSource.executeQuery and FormDataSource.init(). 3. What are the characteristics of a table control? ANSWER - The developer can select which data type the rows and columns in the table should have and the number of columns and rows. 4. List the application objects which are automatically generated by the Wizard . ANSWER - When you run the Wizard wizard it will generate a project, a class, a form, and a Menu item.

1. Which file contains the modification of the form CustTable when developing in the var-layer with an en-us user interface? ANSWER - axVAR.aod. There is no language dependence in the application objects as the user interface texts are stored in the label file. 2. What action must be taken after copying the modifications to the test environment? ANSWER - Start the AOS server and then an AX client in the test environment and make a compilation of the entire AOT followed by a synchronization of the database. 3. How can you determine every application element that is using the method VendTable.balanceMST()? ANSWER - Ensure that the cross-reference has been updated. Find the VendTable.balanceMST() method in the AOT. Right-click, select Addins> Cross-reference > Used By. 4. How can you ensure that a select statement considers record level security? ANSWER - Before the select statement set the recordLevelSecurity() property on the table variable to True.

1. What are the three major components that constitute a Microsoft Dynamics AX 2009 report? Mark all that apply. (Select all that apply.) (√) Designs (√) Datasources (√) Methods ( ) Layouts 2. What is the difference between an AutoDesign specification and a custom GeneratedDesign specification? ANSWER - When you are using AutoDesignSpecs, the report layout is generated when the report is run. Its content and layout are based on the query used for the report. In a GeneratedDesign the layout is dictated by its design structure that is created in the Visual Report Designer and not by a query or report template. 3. A Section group can contain which items? Mark all that apply. (Select all that apply.) (√) Bodies (√) Footers (√) Headers ( ) Page Footers 4. What are some features of the Visual Report Designer that make it an ideal choice for designing reports? ANSWER - The Visual Report Designer allows you to drag and drop report field elements for placement in the report. It

1. The three (3) elements for a Form include: ( ) Methods, Data Sources, and Views (•) Designs, Methods, and Data Sources ( ) Display Menu Items, Data Sources, and Designs ( ) Jobs, Menu Items, and Macros 2. The Area Pages can be customized by: ( ) Making changes to the Areas node in the AOT (•) By making changes to the Menus that the Areas page will automatically be generated from ( ) By setting the IsDisplayedInContentArea property of the Navigation Pane ( ) The Area Pages cannot be changed 3. Available Project types available are: Mark all that apply. (Select all that apply.) (√) Project ( ) Help Project (√) SysTestProject ( ) Test Project 4. Available Menu Items are: Mark all that apply. (Select all that apply.) (√) Display Menu Items (√) Output Menu Items ( ) Project Menu Items ( ) Report Menu Items

1. Task: Put the following steps in order to create a new Primary Index in a table. Step 4 : Add the primary key field(s) to the index Step 3 : Set the Allow Duplicates property on the index to No Step 6 : Set the Primary Index on the Table to the Unique Index Step 1 : Create a new index Step 2 : Set the name for the new index Step 5 : Synchronize the AOT 2. Allowable data types for an index may include: ( ) String, Integer, Real, and Container ( ) String, Enumerated, Real, and Memo (•) String, Integer, Real, and Enumerated ( ) Memo, Container, Map, and integer 3. Nodes required to define a table include: (Mark all that apply.) (Select all that apply.) (√) Fields (√) Field Groups ( ) Maps ( ) Enumerated data types

1. Where should the Business logic be executed with correctly designed objects? ( ) The Client (•) The Application Object Server ( ) The Database Server ( ) Stored Procedures on the SQL Server 2. What three items control security within Microsoft Dynamics AX 2009? ( ) Security Keys, Domains and Companies ( ) User Group Permissions, Security Keys, and Layers (•) License Keys, Configuration Keys and Security Keys ( ) Base Package Keys, X++ Keys, and MorphX Keys 3. Label file ID's that should not be used due to the risk of being overwritten when applying service packs include: ( ) SYS, MBS, USR ( ) SYS, LOS, DIS (•) GLP, HFX, SL1, SYS ( ) SYP, LOP, DIP, SLP

If you are trying to install SharePoint Foundation 2010 Pre-requisites and getting the below error: Application Server Role, Web Server (IIS) Role: configuration error. The tool was unable to install Application Server Role.Web Server (IIS) Role. You are using Windows Server 2012 machine and also has IIS 7.0 installed. Currently, Enterprise Portal is supported only with SharePoint 2010, which is not supported on WindowsServer 2012. Computers where you plan to install Enterprise Portal must run Windows Server 2008 R2 orWindows Server 2008. For more information about SharePoint compatibility with Windows Server 2012,see Microsoft Knowledge Base article number 2724471 SPS 2010 Foundation will support Win 2012 with sp2 not relaesed yet.

If you want to put restriction on the sales order that without confirmation no one is able to do the pick/pack or invoice. I want to share some ideas to do it. you can disable the picklist,Packingslip and Invoice. After PO creation confirmation option enable via code. you need to do some modification in SalesTableType Class.Methods are: CanPickingListbeUpdates, can PackingSlipbeUpdates and canInvoicebeUpdates . Instead doing any customization, you can enable the workflow, which will control stopping pick/pack/Invoice without approve the sales Order.

If you want to create new method at runtime in axapta then you can try following code. To test method you can paste following code in job. TreeNode TreeNode1,tnCust, TreeNdmethod; MemberFunction memberFn; str source; ; TreeNode1 = infolog.findNode(“\Forms\CustTable\Data Sources\CustTable\Fields\Name”); tnCust = infolog.findNode( “\Forms\CustTable“ ); TreeNdmethod = TreeNode1.AOTfindChild( ‘Methods’ ); TreeNdmethod.AOTadd(‘lookup’); memberFn = TreeNdmethod.AOTfindChild( ‘lookup’ ); source = @”public void lookup(FormControl _formControl, str _filterStr) { super(_formControl, _filterStr); }” ; memberFn.AOTsetSource(source, false); memberFn.AOTsave(); TreeNdmethod.AOTsave(); tnCust.AOTcompile();

Sometimes we require to disable to open new workspace in axapta its very simple just you need to disable the option under the tools list within the security permissions . The option is within the 'Select Company Accounts' tree. If you want to restrict multiple user login session then you need to do some code under application or info class in startuppost method.

If you are facing performance issue in axapta 2009 than there may be one reason that some data issue in workflow related tables like WorkflowTrackingTable, WorkflowTrackingStatusTable, WorkflowMessageTable etc. If you have deleted any company then you need to check data in workflow tables. After deletion of company that company data may remain same so you need to delete workflow data for particular company via sql. Other things you need to check version of application and kernel if its different then you can face slow performance for workflow due to some errors. version should remain same.

You can try following code in job to send sms via axapta. This is code sample to get hints to apply in your program. System.Net.WebClient custWebclient; System.IO.Stream InfoData; System.IO.StreamReader Streamreader; System.String URLStr; Str SMSConfirmID; str mobileno='9834045959'; str message='Test SMS'; ; custWebclient=newSystem.Net.WebClient(); URLStr="http://www.smszone.in/sendsms.asp?page=SendSmsBulk&username=87676767645&password=8787&number="+mobileno+"&message="+message; InfoData=custWebclient.OpenRead(URLStr); Streamreader=newSystem.IO.StreamReader(InfoData); SMSConfirmID=Streamreader.ReadToEnd(); InfoData.Close(); Streamreader.Close(); You can try other website too to send sms here smszone.in has been considered to send messages. You need to put your username and password in given url string.

To comple AOT Node by code you can try following code in job. treeNode treeNd; ; treeNd= TreeNode::findNode(#FormsPath); treeNd.AOTcompile(); If you want to schedule time to compile AOT then you can do following things. To create a scheduled task You require to access "Start -> All programs -> Accessories -> System Tools -> Scheduled tasks" and Point the Scheduled Task Wizard to "Ax32.exe" this exe must be in your "client\bin directory" and enter users details like user ID, password and time etc You can either Axapta login window or by entering Network accout name available under Tools -> Options -> General Tab in Axapta. I hope this will work well for you.

Main idea behind exception handling in X++ programming The main idea behind exception handling is to plan for potential pitfalls within the program. These exceptions are inevitable and if the code can expect some of these issues and have contingency plans for the code, the flow of the program is more efficient. The try statement defines a block of code that is included in the try-catch statement. It is used as the point to which the logical program flow will return should it encounter a retry command. The throw statement automatically initiates a ttsAbort statement every time that it is called. The throw statement will force the current transaction to roll back to its original state before the ttsBegin statement.

Using existing indexes on the tables The order by clause in a select statement that will return records in ascending order by default and if specified, can return them in descending order. The group by clause in a select statement will group records by a selected field.

ttsBegin : You mark the beginning of the transaction with ttsbegin. ttsCommit : You mark the successful end of a transaction with a ttscommit.This ensures the transaction is performed the way it is supposed to upon completion. ttsAbort : This can be used as an exception to make a transaction be aborted and rolled back to its state before the ttsbegin. You insert a ttsAbort wherever you want this to occur.

Main difference between using a while statement and a do-while statement The main difference between a While statement and a Do...While statements that the condition is evaluated after the statements are executed in a Do...While statement. Therefore a Do...While statement always runs at least one time even if Condition does not match inside while condition in loop. while(Condition) { statement. } Sample code for Do-while statement.. Do { statement. }While(Condition) Sample code for while statement..

 If Statement: This statement checks whether a condition is true or false.If the statement is true, all the code in the braces '{}' is executed. There are other versions of the If statement including an If…else, or a nested If statement. Switch Statement: This is a multi-branch control statement that defines a condition and whose result determines the code that is executed. A switch statement has multiple cases and for each case there are listed statements that will be executed if that case satisfies the condition. Ternary Operator: This control structure acts as an If…else statement. It is primarily used because it is much more convenient to code than writing out an If…else statement

There are Three main Object-Oriented Programming components in Axapta 1.Classes are blueprints that describe the objects derived from them. A class is a model classification of the methods and variables in a specific type of object. 2.Objects are instances of classes. Each instance has data members andlogic (methods) defined in the class. 3.Methods are functions (subroutines)associated with a class or an object. An object implements its behavior with methods.

 If the DataBase synchronize failed somewhere, below is a link to get code to force the database synchronize in axapta by job. code to force the database synchronize

This is good pdf link which can tell you Top Ten Reasons to Buy Microsoft dynamics ax 2012 in details.  Top 10 Reasons to Buy Ax 2012

Windows Server Windows Server 2008 R2 Service Pack 1 (64 bit) Standard, Enterprise, or Datacenter Windows Server 2012 Release Candidate (64 bit) Standard, or Datacenter. SQL Server SQL Server 2008 R2 Service Pack 1 (64 bit) SQL Server 2012 (64 bit)

The links in this section correspond to file available for this download. SharePoint Designer 2013 64-bit (297.4 MB) SharePoint Designer 2013 32-bit (271.7 MB) Get it here: Microsoft downloads