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

Pradeep Pal 0 Reputation points
2023-08-10T04:55:26.1733333+00:00

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
Azure Database Migration service
Azure SQL Database
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,267 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,214 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 25,326 Reputation points
    2023-08-10T08:13:00.5366667+00:00

    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.

    0 comments