Microsoft Dynamics Products Tips and News!

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Dynamics 365 for Finance and Operation Administration and Troubleshooting, Microsoft Dynamics AX Infrastructure Support, Dynamics 365 operations on-premise (D365),Microsoft Dynamics 365 Admin,Axapta Administrator,AX Administrator,Microsoft Dynamics AX Deployment, Azure,DMF, Excel Add-In, Ware House, AX Mobile apps, Google Cloud, Microsoft Dynamics ISV,Management Reporter 2012 for Microsoft Dynamics ERP, Microsoft SQL, Microsoft Windows Server, SSRS, TFS, POS, Retail, CRM, Microsoft SharePoint, Hyper-V and System Center. Specialist in Azure, Microsoft Dynamics AX Infrastructure Support, Microsoft Dynamics AX Deployment, Implementations, Upgrades, Migrations, Installation, End User Training, User Training, IT/Admin Training, Pre, and Post Go-Live Support activities.

Friday, November 30, 2018

How to fix certificates SSL error on D365fo One box VHD.

Step 1: Create a new self-signed certificate

Run the following Power Shell command (Run as Administrator):

New-SelfSignedCertificate -Subject "CN=*.cloud.onebox.dynamics.com,O=Microsoft Corporation,L=Redmond,S=WA,C=US" -DnsName "*.cloud.onebox.dynamics.com", "usnconeboxax1ecom.cloud.onebox.dynamics.com", "usnconeboxax1pos.cloud.onebox.dynamics.com", "usnconeboxax1ret.cloud.onebox.dynamics.com" -CertStoreLocation "cert:\LocalMachine\My" -KeyUsage DataEncipherment, KeyEncipherment, DigitalSignature -HashAlgorithm "SHA384" -KeyAlgorithm RSA -KeyLength 2048 -NotAfter (Get-Date).AddYears(5)

This would create a new certificate, set to expire in 5 years.

Step 2: Copy the new certificate to the folder where trusted certificates are stored

Open Manage computer certificates (certlm).

Newly generated certificate can be found in the Personal\Certificates folder.

It has the same name as the old one, but different expiration date.

Now copy and paste the new certificate to the Trusted Root Certification Authorities\Certificates folder.

Step 3: Bind the new certificate with D365FO

Open Internet Information Services (IIS) Manager.

Now navigate to the AOSService site (1), click the Bindings link on the right

(2) and select the hostname

(3) and then click the Edit button

(4)The Edit Site Binding dialog opens. Open the SSL certificate drop-down selection box

(5)You will see two certificates with the same name (*.cloud.onebox.dynamics.com). The one selected is probably the old one. Select the other one. Then click the View button to inspect, if you selected the right certificate (by checking the expiry date, for example).

Click Yes if the system asks for confirmation to change the certificate for other related sites.

Close all open dialogs. Restart the AOSService (Click the Restart link under Manage Websites in the vertical pane on the right).

Step 4: Test if the connection to D365FO is treated as safe in Chrome

Restart Chrome and navigate to D365FO. It should work fine.

Sunday, November 4, 2018

How to check which SQL DB is linked with Sharepoint?

How to check which SQL DB is linked with Sharepoint?

Issue:

How to check which SQL DB is linked with Sharepoint?

AX: AX 2012 R3
OS: Windows Server 2012 R2
SQL: SQL 2014
SharePoint:

Solution:

Open SQL> Start RUN>SSMS>

Select the DB>

SELECT program_name, count(*)

FROM

Master..sysprocesses

WHERE ecid=0

GROUP BY program_name

ORDER BY count(*) desc

Now I can see the List of SQL DB which are used in SharePoint!

Happy Querying!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Sunday, September 9, 2018

Microsoft Certifications and Exams News September 2018

This month, Microsoft released two exams and two practice tests. In September, two more practice tests will be ready for the new Azure Administrator exams. New Exams Released on August 17, 2018 MB6-898: Microsoft Dynamics 365 for Talent 70-777: Implementing Microsoft Azure Cosmos DB Solutions (beta; discount codes available, while supplies last, for exams taken before October 1, 2018)
Practice Tests Released 70-774: Perform Cloud Data Science with Azure Machine Learning 70-775: Perform Data Engineering on Microsoft Azure HDInsight Practice Tests Coming in September 2018 on mindhub AZ-101: Microsoft Azure Integration and Security AZ-102: Microsoft Azure Administrator Certification Transition (Original Publication Date: 09/06/2018)

Discount for New Beta Exam 70-777: Implementing Microsoft Azure Cosmos DB Solutions

If you design, build and troubleshoot Azure Cosmos DB solutions, don’t miss this opportunity to take Exam 70-777 (beta) at an 80% discount. The 300 beta seats are available, while supplies last, on a first-come, first served basis, and you must register and take the exam by October 1, 2018. As a developer or an architect, your working knowledge of Cosmos DB helps you meet business and technical requirements. Now you can also use it to help us evaluate the quality of our exam questions, as we build the live exam. We appreciate your voice and welcome your feedback. Get the details, and register today.

Enjoy!

Happy Certifications!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

How to Install Active Directory for Windows 10, Windows 8 and Windows 8.1

Download and install one of the following depending on your version of Windows:

Right-click the Start button and choose “Control Panel“. (Note: In some configurations, you may be able to skip to step 9.)
Select “Programs“.
From the “Programs and Features” section, select “Turn Windows features on or off“.
Scroll down and expand the “Remote Server Administration Tools” section.
Expand “Role Administration Tools“.
Expand “AD DS and AD LDS Tools“.
Ensure that “AD DS Tools” is checked, then select “OK“.
You should have an option for “Administrative Tools” on the Start menu. From there, select any of the Active Directory tools.

Tag: How to Install Active Directory for Windows 10, How to Install Active Directory for Windows 8 and How to Install Active Directory for Windows 8.1

Happy AD!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Sunday, June 3, 2018

Installing Dynamics 365 Finance and Operation On Premises AKA Dynamics 365 Enterprise Server Hardware Sizing

Dynamics 365 Enterprise Server Hardware Sizing

Installing Dynamics 365 Finance and Operation On-Prem(Premises) AKA Dynamics 365 for Finance and Operations (on-premises)

People around the world are asking me this question for Installing the Dynamics 365 Finance and Operation On-Prem(Premises), well this was not so easy.

Let's discuss that what will be the Hardware needed and how much VM's will be used as this is the question which is asked by Customer Company to the Microsoft Partner Company.

Please check the excel sheet for the same.

Steps by Steps Installing Dynamics 365 Finance and Operation On-Prem(Premises)

Happy D365ing for FO!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Tuesday, May 22, 2018

DevOps Ebook,DevOps for Dummies,DevOps Dumps,Putting the Ops in DevOps for Dummies

DevOps Ebook, DevOps for Dummies, DevOps Dumps, Putting the Ops in DevOps for Dummies,
Insights into the mix of technology trends, processes, and best practices, and IT organizations and role shifts impacting DevOps.

DevOps is the combination of cultural philosophies, practices, and tools that increase an organization’s ability to deliver applications and services at high velocity: evolving and improving products at a faster pace than organizations using traditional software development and infrastructure management processes. This speed enables organizations to better serve their customers and compete more effectively in the market.

Free copy download for the link!

Happy DevOpsing!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Sunday, April 15, 2018

Financial Reporting for Dynamics AX 2012. Management Reporter

Financial Reporting for Dynamics AX 2012. Management Reporter – your financial reporting solution for Dynamics AX. Management Reporter Benefits. Direct integration with general ledger; Custom financial reports to fit your business; Dynamic report layouts reduce maintenance

PPT: Powerpoint for Management Report AX 2012

Happy DAXing!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Tuesday, April 10, 2018

Kill online user in Dynamics AX 2012

Kill online user in Dynamics AX 2012

How to Kill online user in Dynamics AX 2012?

Solution:

Stop AOS

Open SQL

truncate table SysServerSessions

truncate table SysClientSessions

Happy DAXing!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Wednesday, March 14, 2018

The model store has been modified, How to skip The model store has been modified dialog in AX 2012

The model store has been modified,
How to skip The model store has been modified dialog in AX 2012

Issue:

The model store has been modified,

How to skip The model store has been modified dialog in AX 2012

AX: AX 2012 R3
OS: Windows Server 2012 R2
SQL: SQL 2014

Solution:

Well, we have three solutions:

The easiest way to get rid of it to uncheck the MinorUpgrade checkbox on the ReleaseUpdateConfiguration table. Close the Client and start it again.

You can also alternatively create a job that runs SysCheckList_Update::finalizeMinorUpgrade();

as below:

static void Job11(Args _args)
{
SysCheckList_Update::finalizeMinorUpgrade();

}

You can also use this "Set-AXModelStore NoInstallMode" via Power Shell

Happy DAXing!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Monday, February 19, 2018

Microsoft Dynamics AX 2012 Performance monitoring and Diagnostic Tools

Microsoft Dynamics AX 2012 Performance monitoring and Diagnostic Tools

Please find the below diagnostics tools for performance monitoring w.r.t AX 2012 and above>

Trace Parser (https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/perf-test/trace-parser)
Performance Monitor (https://technet.microsoft.com/en-us/library/cc961845.aspx)
AX Diagnostic Framework Tool (https://community.dynamics.com/ax/b/brandongeorge/archive/2013/01/08/microsoft-dynamics-ax-diagnostic-framework-beta)
Performance Analyzer for Microsoft Dynamics AX (DynamicsPerf) (https://blogs.msdn.microsoft.com/axinthefield/dynamicsperf-2-0-deployment-guide/)
Life Cycle Services (https://lcs.dynamics.com/Logon/Index)
Intelligent Data Management Framework (IDMF) (https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/lifecycle-services/ax-2012/overview-idmf)
System Center Operations Manager Monitoring Pack for Microsoft Dynamics AX 2012 (https://www.microsoft.com/en-in/download/details.aspx?id=26934)
Performance Analysis of Logs (https://archive.codeplex.com/?p=pal )

On the SQL side, we can see

Activity Monitor
Extended Events
Management Data Warehouse

Windows Server Performance Tools

Disk Defragmentation
Disk Cleanup
Event Viewer
Memory Utilization
Performance monitor
Memory cleaner
Debugdiag
Windbg

Network Performance Tools

Packet analyzer
Performance monitor
Command Prompt
Firewall
Task Manager
Router & Switch
Network Monitoring
Wireshark (https://www.wireshark.org)
Fiddler

Happy DAXing!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Thursday, February 15, 2018

The requested Workflow action failed

The requested Workflow action failed

Issue: The requested Workflow action failed

I got following error "The requested workflow action failed." when I click on Email Approval link!

AX: AX 2012 R3
OS: Windows Server 2012 R2
SQL: SQL 2014

Solution:

I followed the two steps:

1. Redeploy SysWorkflowApprovalServices and SysWorkflowApprovalServiceGroup

We can do this in AOT (ctrl+d) then got to service groups and

Go to SysWorkflowApprovalServices and

SysWorkflowApprovalServiceGroup

right click on it and click Redeploy one by one.

and

2. Deactivate and Activate EmailApprovalServices (It might of different name in your company)

Go to Microsoft Dynamics AX, click System Administration > Services and Application integration framework > Inbound ports look for EmailApprovalService Deactivate and Activate again and re-test!

Bingo!

Its fixed,

Happy DAXing!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Friday, February 9, 2018

The web browser running the add-in is not allowing access to local or session storage. Please adjust the environment and consult the support pages if necessary.

The web browser running the add-in is not allowing access to local or session storage. Please adjust the environment and consult the support pages if necessary.

Note – You must need to get help from IT if you don’t have administrator rights on your computer.

Also, we can get this scripted to run at system startup.

Error –

When the user clicks on “open with Excel” on D365, Excel gives the error.

"The web browser running the add-in is not allowing access to local or session storage. Please adjust the environment and consult the support pages if necessary."

Resolution –

Go to windows and search for command prompt window by typing “cmd”.

Right-click and “Run as administrator”

Copy below line and paste it inside command prompt

icacls %userprofile%\Appdata\LocalLow /t /setintegritylevel (OI)(CI)L

Hit “Enter” and you should get the message.

Refresh D365 browser before exporting data to excel.

Happy D365ing!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

Saturday, January 6, 2018

Today I Passed the Microsoft MB2-708 Microsoft Dynamics CRM Installation!

Preparing for MB2-708 Microsoft Dynamics CRM Installation Exam:

MB2-708 is Microsoft Dynamics CRM 2015 Installation certification with the focus on On-Premise setup.

I remember I was in Singapore, I was here to install Microsoft Dynamics AX 2012 R3 CU 8, eventually, I came to know that I need to install Microsoft Dynamics CRM 2015.

This was a big tricking one, however, I made it work and later I thought of giving the exam.

It also covers working with relevant technologies, techniques, and tools such as Email Router, Deployment Manager, Active Directory, Federation, SQL Server, VSS, Network Load Balancing, etc.

You should check Exam MB2-708 for more details.

Happy CRM Infra!

Thanks & Regards,

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh