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)
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.
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:
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.