Tag Archives: Microsoft SQL Server

  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 …

Most of my blog posts on which I confronted in my daily routine job. Our development team has reported an error they are getting an error screen while preview the SSRS reports from visual studio 2013. Error: Unable to preview the report, install the Microsoft SQL Server Data Tools – …

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. …

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”