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”

Advertisements

Add a scrollbar for ASP.NET AJAX Modal popup extender inside SharePoint Visual WebPart

I am using the ModalPopUpExtender in Visual WebPart, I need to allow vertical scroll therefore, I set the Panel Property  ScrollBars=”Vertical” as shown:

scrollbars

But unfortunately, the scroll still not working !! as shown below:

ScrollIssue

Solution: Continue reading “Add a scrollbar for ASP.NET AJAX Modal popup extender inside SharePoint Visual WebPart”

No http handler was found for request type ‘GET’ in SharePoint Visual WebPart

I tried to use Asp.Net Chart control within SharePoint Visual WebPart, After I deployed the SharePoint Solution, I tried to add Chart visual webpart to SharePoint page, I got the following server error.

No http handler was found for request type 'GET'

Chart Configuration

Cause: Continue reading “No http handler was found for request type ‘GET’ in SharePoint Visual WebPart”

Load FancyBox popup only once per session when browse SharePoint site

In this article, I will elaborate How to show a fancybox popup in SharePoint.

  • In my Scenario:
    • I need to show a fancybox popup window only once per session when I open a SharePoint site for the first time.

I  checked the type of modal popup and found the FancyBox is fantastic popup that meet my requirement.

The Output should be look like the following

AD

Steps:
Continue reading “Load FancyBox popup only once per session when browse SharePoint site”

Changing NLS_LANGUAGE Oracle Parameter via C# in ASP.NET

I am working on ASP.NET web application to retrieve a data from oracle database via C# that has been retrieved successfully,

ِAbout a week ago,I found out the format of retrieving data has been changed, and the web application raises unexpected behavior although I didn’t change any thing in my code.

Cause : 

This might occurred if NLS_LANGUAGE Oracle Parameter has been changed from AMERICAN to ARABIC.

1 Continue reading “Changing NLS_LANGUAGE Oracle Parameter via C# in ASP.NET”

Replace a broken image with a default image via JavaScript In ASP.NET

At previous Article, I explained How to retrieve BLOB Field from Oracle DB via ASP.Net but I found out when an employee not have image in database the output look like as broken
Therefore, I need to replace any broken image with a default image by following the bit steps below : Continue reading “Replace a broken image with a default image via JavaScript In ASP.NET”

How to retrieve a BLOB Field from Oracle DB via ASP.NET

At this article, I will demonstrates How to integrate ASP.NET Web Application with Oracle Database to retrieve a BLOB  field from Oracle database side and show it in ASP.NET page.

Steps :

Open Visual Studio > Open existing  ASP.NET Solution > Add <img> tag within a page that should be look like this

<img id="EmpImg" 
src="ShowImage.ashx?Account=<%=Request.QueryString["Account"]%>"
alt="" width="100px" height="100px" style="float:right"/>

Note:  The image source is a generic handler called  ShowImage.ashx?  Continue reading “How to retrieve a BLOB Field from Oracle DB via ASP.NET”