Author: admin

Microsoft SQL Server Reporting Services (SSRS) web service Warning in Dynamics AX 2012

I was facing this prerequisite validation warning/error (Microsoft SQL server Reporting Services Web Service) when I was installing the “Reporting services extensions” component in AX 2012. The Reporting services on SQL Server 2012 have already been configured and the Web Service URL is http://Myservername:80/DynamicsAXReporServerVD SOLUTION: Navigate to this path DriveName:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\RSReportServer.config and replace this link https://localhost:443 with… Read more →

ERROR: System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.SmoExtended)

SQL SERVER 2012 DATABASE RESTORE Solution: Either you can solve this issue by running a query or via DB UI   Right click on your database that  you want to restore> properties > options > State > Restrict Access > select Single user (single user to cut off all the connections to the db that you are restoring) Restore your… Read more →

Workflow Error – An unexpected error has occurred while opening the workflow. See the event log on the AOS and contact your system administrator to resolve the issue

There might be other solutions besides this one, but these are the steps i followed to solve the error above. I am using AX 2012 R3 CU8, and special thanks to my co-worker (Anja) who helped me with this solution: SOLUTION: Refresh WCF in client configuration: In Administrative Tools select AX 2012 Configuration in Configuration Target select Business Connector (non-interactive use… Read more →