Category Archives: Dynamics AX and SQL Server

AOS service installation issue

When I tried to install AOS component after installing the Application and database feature, I get the error message: could not open connections to the host, on port 1433: connect failed The solution is to enable the TCP/IP protocol on … Continue reading

Posted in Dynamics AX and SQL Server | Leave a comment

How to Use PowerShell to backup and delete AX application and database

There are many VPCs running in our Virtual Server for the Client Development purpose. As we develop a lot on the AX applicatoins, we need to backup the application and database everyday and also before the main changes in AX. … Continue reading

Posted in Dynamics AX and SQL Server | Leave a comment

SQL Server Database backup for AX

Recently, one of our clients requires to backup the AX Database Log files frequently due to the mass transaction files written to database in working hours. Due to the case study, we decide to backup AX database and log files … Continue reading

Posted in Dynamics AX and SQL Server | Leave a comment

AX Reports Deployment Error: Native compiler return value: ‘[BC30137] Error saving temporary Win32 resource file ‘C:\Windows\TEMP\vbc5CA1.tmp’: System Error &H80070020&’.

[Scope] Deployment failed unexpectedly with the message:An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC30137] Error saving temporary Win32 resource file ‘C:\Windows\TEMP\vbc5CA1.tmp’: System Error &H80070020&’. See the log file for further details.   [Environment] Windows 2008, AX … Continue reading

Posted in Dynamics AX and SQL Server | Leave a comment

AX 2009 Reports are frozen in the Microsoft Dynamics AX VPC In Hyper V server

When we run the AX SSRS reports in the Microsoft Dynamics AX VPC, we find that the reports is generating but don’t show it some times. The error log in the SQL Reporting server is: w3wp!library!1!11/20/2009-09:27:08:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: … Continue reading

Posted in Dynamics AX and SQL Server | Leave a comment

Dynamics AX 2009 SP1 Reports Deployment Issue on SQL Server 2008

One of our clients tried to install SQL Server 2008 Reporting Services with Microsoft Dynamics AX 2009 Reporting Extensions on a 64-Bit Windows Server 2008 system. But they have got some error messages during the AX reporting extensions installation and … Continue reading

Posted in Dynamics AX and SQL Server | Leave a comment

Deny access to some AX tables from Sql Server Management Studio

Questions: I’m setting up a new SQL Server  2005 instance which will host a Dynamics AX DB. I needed to deny access to some AX tables to some users, so I set up the rights from within AX and everything is fine. Now … Continue reading

Posted in Dynamics AX and SQL Server | Leave a comment