Troubleshooting Tip Dynamics AX 2009 Enterprise Portal - Return of the Error An existing connection was forcibly closed by the remote host

Dear Friends,

Hope you are doing well.

Four years ago, I had an issue installing Enterprise Portal in a distributed environment mentioned in my blog post here.

The error is "An existing connection was forcibly closed by the remote host"

Fast forward to 2013, I'm helping a customer setup Enterprise Portal with SQL Server on a different box, and again hit the same error this time with SQL Server 2008 R2.

There's an article on technet about this error and troubleshooting http://technet.microsoft.com/en-us/library/ee355087(v=ax.50).aspx

And, in the above link we have 2 solutions one for SQL Server 2005 and SQL Server 2008. In my current scenario, I'm on SQL Server 2008 R2. So, if you are on SQL Server 2008, Navigate to the below link to download the AMO Objects required to be installed on the EP box

http://www.microsoft.com/en-au/download/details.aspx?id=16978

 

Hope the above link and screenshot will help someone out there troubleshooting EP Setup.

 

 

SQL Server CTEs and Recursive Parent Grouping in Advanced Mode Group Properties in SSRS

Hello!

Few weeks ago, I was developing an interesting report in SSRS which pulls out data from AX - Projects module.

It was interesting for 2 reasons:

1. I learned to use more effectively SQL Server CTE's (Common table expressions) while developing this report.

From a layman's perspective, CTEs were introduced since SQL Server 2005 and it’s more useful to do a recursive search (display hierarchical data e.g. employee-manager, BOM etc). In my scenario, I had to do a recursive search for Project-Parent Id in my Stored proc)

Below sharing some links, which will explain further more in detail about CTE's and how to implement them.

http://msdn.microsoft.com/en-us/library/ms186243(v=sql.105).aspx

http://msdn.microsoft.com/en-us/magazine/cc794278.aspx

2.  The second concept was about recursive parent Grouping (in SSRS)

In SSRS, we can group the child field based on the recursive parent key (There’s an option in the Edit Group > Advanced Section to key in the Recursive parent field) – explained here in this blog - http://sql-bi-dev.blogspot.com.au/2010/08/recursive-hierarchy-group-in-ssrs-2008.html