I was involved in setting up EP and Workflow on our Production boxes this weekend. This is a distributed environment where we have IIS/EP, AOS and SQL Server on different boxes. Had completed MOSS configuration without any glitch, but while installing EP and Role centers, I went through a sequence of issues. My EP and Role center installation got completed with warnings, but the website was not coming up. The errors in Event viewer and the log file were -
"“Faulting application w3wp.exe, version 6.0.3790.3959, stamp 45d6968e, faulting module kernel32.dll, version 5.2.3790.4062, stamp 46264680, debug?”
An error occured while Setup was creating a new site.
The underlying connection was closed: An unexpected error occurred on a receive.
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object parameters)
at Microsoft.Dynamics.Framework.Deployment.Portal.WSSAdmin.CreateSite(String Url, String Title, String Description, Int32 Lcid, String WebTemplate, String OwnerLogin, String OwnerName, String OwnerEmail, String PortalUrl, String PortalName)
at Microsoft.Dynamics.Framework.Deployment.Portal.EPDeployment.CreateDefaultEPSite(String virtualServerUrl)
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host
API return status: Warning
Solution - After spending hours of troubleshooting, later learnt the hard way from the below post that we have to install SQL Server 2005 Client Tools on the IIS/EP box if EP is running in a distributed environment.
Thanks to Arijit for putting up this great post!!