Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgment

I have an ASP.Net website that connects to SQL server always-on failover cluster instance.

But I have a strange behavior when I configured the Connection String inside Web.Config as SQL Authentication, the connection has been connected successfully.

Server=load balancer IP;Database=Database Name;User Id=User; Password=Password; 

Bu when I tried to configure the Connection String as Windows Authentication.

Server=load balancer IP;Database=Database Name;Integrated Security =true;

I got the following error.

Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.
This could be because the pre-login handshake failed or the server was unable to respond back in time.

connection-timeout-expired.png

I made sure that the application pool service account has elevated privilege with SQL Server as public server role and user mapping database. but unfortunately, the issue still persist.

Cause: Continue reading “Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgment”

Health Analyzer Issue: Product/patch installation or server upgrade required

In SharePoint 2013, the Health Analyzer has detected the below error:

Product / patch installation or server upgrade required

Product patch installation or server upgrade requiredCause: Continue reading “Health Analyzer Issue: Product/patch installation or server upgrade required”

WorkflowCannotStartWorkflow (35100) In Project Server 2013

During creating a new Project in Project Server 2013, I got the following error details

GeneralQueueJobFailed (26000) GeneralQueueJobFailed (26000) –WorkflowCheckinNotify.ProjectCheckinNotifyWorkflowMessage.

error 26000 workflow check-in in project server

Scenario: Continue reading “WorkflowCannotStartWorkflow (35100) In Project Server 2013”

View, Edit, Delete options are missing within Manage Project Web Apps in Project Server

When I tried to manage a PWA Instance within the Central administration in Project Server 2013 by navigating to

  • Central Administration > Application Management > Manage Service Applications.

Application Management

  • Click on PWA Application Service.
  • Select PWA Instance then clicks on its right arrow to manage it but unfortunately, I couldn’t find View/Edit/Delete option as shown below.

Manage Project Web Apps - Project Server - DevoWorx

Cause Continue reading “View, Edit, Delete options are missing within Manage Project Web Apps in Project Server”

Microsoft SharePoint Server 2013 encountered an error during setup

During installing SharePoint Server 2013 with Service Pack 1 on Windows Server 2012 R2 using Hyper-V Manager, I got the following error :

“Microsoft SharePoint Server 2013 encountered an error during setup”

Microsoft SharePoint Server 2013 encountered an error during setup

Cause: Continue reading “Microsoft SharePoint Server 2013 encountered an error during setup”