SQLSTATE[HYT00]:[Microsoft][ODBC Driver 18 for SQL Server]Login timout expired from Azure App Service with Linux container

Question

SQLSTATE[HYT00]:[Microsoft][ODBC Driver 18 for SQL Server]Login timout expired from Azure App Service with Linux container

Vijay NT 21

We have an application in Codeigniter that connect to a SQL Server database. The application is a docker Linux container hosted in Azure App Service. We are getting the following error randomly

SQLSTATE[HYT00]:[Microsoft][ODBC Driver 18 for SQL Server]Login timout expired

We are using PDO and SQLSRV. The PHP version used is 8.1. Recently we have upgraded the PHP from 7.3 to 8.1. Earlier the application hosted Linux VM.

Thanks for any help in advance.

Erland Sommarskog 67,721 Reputation points Microsoft MVP

2023-01-10T22:22:42.687+00:00
The first thing that comes in mind is that there is a intermittent network problem.

Ini any case, you should absolutely add the appropriate azure tags to your post, since may be an issue in Azure.

But there is one thing you should check in SQL Server. Run this:

SELECT * FROM sys.dm_os_wait_stats WHERE wait_type = 'THREADPOOL'
ShaktiSingh-MSFT 4,671 Reputation points Microsoft Employee

2023-01-13T09:41:21.6033333+00:00

Hi @Vijay NT ,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Erland Sommarskog 67,721 Reputation points Microsoft MVP

2023-01-10T22:22:42.687+00:00

The first thing that comes in mind is that there is a intermittent network problem.

Ini any case, you should absolutely add the appropriate azure tags to your post, since may be an issue in Azure.

But there is one thing you should check in SQL Server. Run this:

SELECT * FROM sys.dm_os_wait_stats WHERE wait_type = 'THREADPOOL'
ShaktiSingh-MSFT 4,671 Reputation points Microsoft Employee

2023-01-13T09:41:21.6033333+00:00

Hi @Vijay NT ,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

SQLSTATE[HYT00]:[Microsoft][ODBC Driver 18 for SQL Server]Login timout expired from Azure App Service with Linux container

Activity