Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / The semaphore timeout ...
Finance forum
Suggested answer

The semaphore timeout period has expired SQL D365 f&o

Posted on by 121
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!
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 5,178 Super User 2024 Season 2 on at
    The semaphore timeout period has expired SQL D365 f&o
    Hi,
     
    You can follow my blog that I wrote about connecting Test/UAT to Dev 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.
     
  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,538 Moderator on at
    The semaphore timeout period has expired SQL D365 f&o
    Do you have any VPN while connecting to server? Because error doesn't seem to be coming from SSMS.
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,347 Super User 2024 Season 2 on at
    The semaphore timeout period has expired SQL D365 f&o
    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.
     
     
    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.
     
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    The semaphore timeout period has expired SQL D365 f&o
    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
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    The semaphore timeout period has expired SQL D365 f&o
    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:
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 9,180 Super User 2024 Season 2 on at
    The semaphore timeout period has expired SQL D365 f&o
    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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,326 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,166 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans