Sql-server – Connectivity to SQL Server on Azure Error: 121 – The semaphore timeout period has expired

sql server

I having trouble connecting to a SQL Server database on Azure. We've already added the IP address to the firewall exclusion list and the username/password work when connecting from other machines. We tried with both username/password and MFA.

What else could be causing the problem?

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 – The semaphore timeout period has expired.) (Microsoft SQL Server, Error: 121)

Best Answer

try to connect choosing the proper user database here:

Maybe the user you are using is not able to connect to the master database.

Here is how database firewall rules work:

https://docs.microsoft.com/it-it/azure/azure-sql/database/firewall-configure

Related Solutions

Sql-server – SQL Server Connectivity Issues

OK, so odds are it isn't link that Up_One posted.

SQL Server does all it's work via schedulers. Each scheduler is attached to a CPU core on the server. Usually when I've seen that error it's because the CPUs are very busy and can't properly respond to the request in the time needed.

What's the CPU workload on the SQL Server look like when the problem happens? How many users are running queries at that time? How many CPU cores does the server have?

The fix is to reduce the CPU workload on the server. Typically this is done by doing index tuning on the system which will reduce CPU workload.

Sql-server – SQL Server: Frequent Login timeout expired in Linked server

I am here answering my own question. After so many observations and experiments with searching over the internet, I found solution to this issue. You need to run this simple query

USE Yourdatabase;
GO
EXEC sp_configure 'remote query timeout', 0 ;
GO
RECONFIGURE ;
GO

The setting takes effect immediately without restarting the server.

Please refer Configure the remote query timeout Server Configuration Option and sp_configure.

Best Answer

Related Solutions

Sql-server – SQL Server Connectivity Issues

Sql-server – SQL Server: Frequent Login timeout expired in Linked server

Related Question