Finance | Project Operations, Human Resources, ...

The semaphore timeout period has expired SQL D365 f&o

(2) Share

Report

Posted on by CU21052024-0

265

Hi All,

When I try to Point D365 F&O UAT Azure SQL DB to DEV, I'm getting below error message.

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.) (.Net SqlClient Data Provider)

Steps followed: Added DEV IP address and enable write access for UAT from LCS. entered credentials to DEV SQl server (server name, sql cred: username, pwd, database name)

Can anyone help me to resolve this error please

Thanks in advance!

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

I guess the issue is due to the firewall.

please try to connect from another computer (don't forget to add the new Ip address).

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Judy Microsoft Employee on at

Like (1)

Report

Hi, please check for any network-related issues, such as firewall settings or network congestion. Here are some useful links regarding the issue you can refer to:

https://learn.microsoft.com/en-us/answers/questions/1343739/a-connection-was-successfully-established-with-the

Errors when applications try to connect to SQL Server in Windows - Windows Server | Microsoft Learn

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
You can check out this blog which mentions that when connecting to SQL Server, you may receive the following error message:
Lesson Learned #268:Error occurred during the pre-login handshake-The semaphore timeout period - Microsoft Community Hub

Best regards,
Hana

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,407 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Believe you have configurated these parameters in the web.config file and saved your original web.config in a different location, as per the documentation link mentioned below.

References: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/dbmovement-scenario-debugdiag

The other stuff that you need to enable is to ensue that you by pass the firewall to include the local host machine IP address (Cloud machine on which the SQL Server Management studio resides) within Dynamics Lifecycle Services -> <YourprojectName> -> <theenvironmenttoConnectTo> and follow the screen clips mentioned below.

Happy to answer questions, if any. Hope this helps.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Do you have any VPN while connecting to server? Because error doesn't seem to be coming from SSMS.

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

You can follow my blog that I wrote about connecting Test/UAT to Dev Environment.

https://butterflywaeda.hashnode.dev/connect-d365-test-db-to-the-development-environment

It seems you don't do enable access to your Dev Box IP Address.

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue.

Was this reply helpful? Yes No