I received above errors during initial Data Mart Integration. Errors are appear in the Data Mart Integration log and Event viewer. To resolve the above error, we have to enable TCP/IP connection in ‘SQL Server Configuration Manager’. Please see highlighted text in the below screen. “Yours, Ravi Theja Madisetty …
Read More »Tag Archives: Microsoft SQL Server
Unable to preview the report, install the Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013
When I tried to preview AX report in Visual studio 2013, received above error. As per the Tech Net / blogs, In SQL 2014, Business intelligence feature is removed. Previous versions of SQL 2014 (ex: SQL2012SP1) Business intelligence feature is available with name ‘SQL Server …
Read More »Unable to access Navision Development Environment. Getting error “login failed for user domain name \userid”
Resolution: If you want to access development environment user must have proper rights on SQL server. Please refer TechNet Blog for more information. Follow below steps to assign rights for a user id to access Navision Development Environment: Open SQL management studio with SQL administrator ID. Expand the Security node, right-click Logins, and choose New Login. …
Read More »How to change the status of BatchJobs in AX2012 By using Sql qurery (Withhold status)
select * from BATCHJOB; update BATCHJOB set status = 0 where status = 1; Or select * from BATCHJOB; update BATCHJOB set status = 0 where status in (1,2,3,4) “Yours – Ravi Theja Madisetty”
Read More »