The requested operation requires elevation.? on command prompt resulting the ipconfig /flushdns

The requested operation requires elevation.

Why do we see The requested operation requires elevation.? on command prompt resulting the ipconfig /flushdns ?

Solution: type cmd on search and the "Run as Administrator"

Happy CMDing!

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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. 

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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

Microsoft Certifications and Exams News September 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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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

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

1. Download and install one of the following depending on your version of Windows:
• Remote Server Administrator Tools For Windows 10
•  Remote Server Administrator Tools For Windows 8
•   Remote Server Administrator Tools For Windows 8.1
2. Right-click the Start button and choose “Control Panel“. (Note: In some configurations, you may be able to skip to step 9.)
3. Select “Programs“.
4.  From the “Programs and Features” section, select “Turn Windows features on or off“.
5. Scroll down and expand the “Remote Server Administration Tools” section.
6. Expand “Role Administration Tools“.
7. Expand “AD DS and AD LDS Tools“.
8. Ensure that “AD DS Tools” is checked, then select “OK“.
9. 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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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>

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

On the SQL side, we can see

1. Activity Monitor
2. Extended Events
3. Management Data Warehouse

Windows Server Performance Tools

1. Disk Defragmentation
2. Disk Cleanup
3. Event Viewer
4. Memory Utilization
5. Performance monitor
6. Memory cleaner
7. Debugdiag
8. Windbg

Network Performance Tools

1. Packet analyzer
2. Performance monitor
3. Command Prompt
4. Firewall
5. Task Manager
6. Router & Switch
7. Network Monitoring
8. Wireshark (https://www.wireshark.org)
9. Fiddler

Happy DAXing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

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

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,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

Update on Exam Retirements For Microsoft Certification,Microsoft Exam list for Retirement Schedule 2018

Update on Exam Retirements For Microsoft Certification, Microsoft Exam list for Retirement Schedule 2018 


To keep the Microsoft Certified Professional program current,
Microsoft Learning continually monitors trends and then revises exams and certification requirements to keep pace with technology changes.
Our goal is to provide you with several months’ notice of upcoming exam retirements.
We review our certification program plan, the psychometric performance, and our upcoming exam list every quarter and make decisions about what to retire and when so that we can ensure people have the most up to date certifications reflecting the latest in Microsoft technologies while at the same time ensuring that MCPs can be certified on the technologies they use every day.

If a replacement exam is or will be available, it is listed here. Any changes from last month's post are in italics.

Retire December 31, 2017 
70-246: Monitoring and Operating a Private Cloud
70-247: Configuring and Deploying a Private Cloud
70-534: Architecting Microsoft Azure Solutions (replacement exam: 535)
74-344: Managing Programs and Projects with Project Server 2013
74-678: Designing and Providing Microsoft Volume Licensing Solutions to Large Organizations (replacement exam: 70-705)
MB2-709: Microsoft Dynamics Marketing
MB6-705: Microsoft Dynamics AX 2012 R3 CU8 Installation and Configuration (replacement exam: MB6-894)
MB6-890: Microsoft Dynamics AX Development Introduction (replacement exam: MB6-894
MB6-892: Microsoft Dynamics AX Distribution and Trade (replacement exam: MB6-896)
MB6-893: Microsoft Dynamics AX Financials (replacement exam: MB6-895)

Retire March 31, 2018 

70-696: Administering System Center Configuration Manager and Intune (replacement exam: 70-703)

Retire July 31, 2018 
70-398: Planning for and Managing Devices in the Enterprise
70-488: Developing Microsoft SharePoint Server 2013 Core Solutions
70-489: Developing Microsoft SharePoint Server 2013 Advanced Solutions
70-496: Administering Visual Studio Team Foundation Server
70-497: Software Testing with Visual Studio Retire
70-498: Delivering Continuous Value with Visual Studio Application Lifecycle Management
70-680: Windows 7, Configuring
70-685: Windows 7, Enterprise Desktop Support Technician
70-686: Windows 7, Enterprise Desktop Administrator
74-343: Managing Projects with Microsoft Project 2013

74-409: Server Virtualization with Windows Server Hyper-V and System Center

Source

Happy DAXing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

Set up and deploy on-premises environments,Installation D365 on Prem

Set up and deploy on-premises environments, Installation D365 on Prem


https://docs.microsoft.com/en- us/dynamics365/unified- operations/dev-itpro/ deployment/setup-deploy-on- premises-environments


Check 

Dynamics 365 for Finance and Operations, Enterprise edition (on-premises) system requirements

Happy D365ing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged

An operation that uses the database driver could not be completed.

If the driver is a Microsoft driver, make sure the driver file isn't damaged,

and it is, reinstall the driver by reinstalling Microsoft Query.

Error:

An operation that uses the database driver could not be completed.

If the driver is a Microsoft driver, make sure the driver file isn't damaged,

and it is, reinstall the driver by reinstalling Microsoft Query.

Solution:

Well in my case it worked by giving the user access to the DB it is accessing. 

Happy DAXing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

an error occurred while attempting to retrieve the list of local SharePoint sites configured with reporting services.

An error occurred while attempting to retrieve the list of local SharePoint sites configured with Reporting Services.


Yesterday When I tried to Install the Reporting Extension I faced this error.


Error:

An error occurred while attempting to retrieve the list of local SharePoint sites configured with Reporting Services.

AX: Microsoft Dynamics AX 2012 R3 CU8
OS: Microsoft Windows Server 2012 R2
SQL: Microsoft SQL Server 2014
SP: Microsoft SharePoint Server 2013

Solution:

Well, the first thing I checked was the event viewer, there was an access related issue with DB.

I opened the SSMS, Checked the service account, gave it sysadmin access and bingo! :)

Happy DAXing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit