how to fix Error type Failed to connect Error Detail Error 258 - SQL connection failed. with source sql server

Question

While creating new migration project in Data Migration Service. in select source i'm getting this error.

instance credential is correct, enabled tcp/ip, remote connections are allowed.

failed to connect.

Error type
Failed to connect, please check error details
Error Detail
Error 258 - SQL connection failed.

Please use this interactive user guide to troubleshoot the connectivity issue:  https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server
        
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)
The wait operation timed out

Answer 1

Hi @Pradeep Pal

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.) The wait operation timed out

Please refer to this tech doc for more details: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.