web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Cloud Migration: The s...
Small and medium business | Business Central, N...
Answered

Cloud Migration: The server timed out while attempting to connect ot the specified SQL Server

(0) ShareShare
ReportReport
Posted on by Community Member

Dear Experts,

I'm attempting to do to a Cloud migration from on-prem to BC online and I can't get past the Data migration Setup. It's giving me the error: "The server timed out while attempting to connect to the specified SQL server."

pastedimage1603329714813v2.png

The Integration Runtime is alsoconnected.

pastedimage1603329828755v3.png

Test connection also succeeded

pastedimage1603329876298v4.png

The event logs for the Integration  Runtime is not also giving me any useful infos.

pastedimage1603329957455v5.png

Any suggestions would be helpful!

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    How large is the dataset that needs to migrate to cloud?

    Thanks.

  • Community Member Profile Picture
    Community Member on at

    Hi!

    The database on the On-prem is currently at 16.8GB. Is that what you meant by the dataset size?

  • Community Member Profile Picture
    Community Member on at

    I found this error log in the Event Log while attempting to complete the Data migration Setup.
    pastedimage1603420888478v1.png

    Copy failed with error: 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Query source database timeout after '300' seconds.,Source=Microsoft.DataTransfer.DataContracts,StackTrace=   at Microsoft.DataTransfer.Common.Shared.HelperMethod.ExecuteWithTimeout(Action action, TimeSpan timeout, HybridDeliveryExceptionCode exceptionCode, String errorMessageFormat)

      at Microsoft.DataTransfer.ClientLibrary.SqlTabularSource.GetReader()

      at Microsoft.DataTransfer.ClientLibrary.SqlTabularSource.Read()

      at Microsoft.DataTransfer.Runtime.SourceStageProcessor`1.ProcessInternal(NoData data)

      at Microsoft.DataTransfer.Runtime.PipelineProcessStageProcessor`2.Process(TInput data)

      at Microsoft.DataTransfer.Runtime.Provider.HybridRuntimeDataReader..ctor(HybridRuntimeCommand command, String commandBehavior, IMemoryLimit memoryLimit, Int32 previewCount)

      at Microsoft.DataTransfer.Runtime.Provider.HybridRuntimeCommand.ExecuteReaderInternal(String commandBehavior, Int32 rowCount)

      at Microsoft.DataTransfer.TransferTask.ExecuteQueryAsyncTask.QueryDataToInternalBlob()

      at Microsoft.DataTransfer.TransferTask.CopyTaskBase.Execute(),''Type=System.TimeoutException,Message=,Source=Microsoft.DataTransfer.DataContracts,StackTrace=   at Microsoft.DataTransfer.Common.Shared.HelperMethod.ExecuteWithTimeout(Action action, TimeSpan timeout, String timeoutErrorMessage)

      at Microsoft.DataTransfer.Common.Shared.HelperMethod.ExecuteWithTimeout(Action action, TimeSpan timeout, HybridDeliveryExceptionCode exceptionCode, String errorMessageFormat),'

    Job ID: 07d91b90-a0e0-4acc-8a03-31564e04904a

    Log ID: Error

    DEBUG:
    TraceComponentId: TransferTask
    TraceMessageId: TransferRunFailed
    @logId: Error
    FunctionName: Execute
    jobId: 07d91b90-a0e0-4acc-8a03-31564e04904a
    activityId: 07d91b90-a0e0-4acc-8a03-31564e04904a
    eventId: TransferRunFailed
    message: Copy failed with error: 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Query source database timeout after '300' seconds.,Source=Microsoft.DataTransfer.DataContracts,StackTrace=   at Microsoft.DataTransfer.Common.Shared.HelperMethod.ExecuteWithTimeout(Action action, TimeSpan timeout, HybridDeliveryExceptionCode exceptionCode, String errorMessageFormat)
       at Microsoft.DataTransfer.ClientLibrary.SqlTabularSource.GetReader()
       at Microsoft.DataTransfer.ClientLibrary.SqlTabularSource.Read()
       at Microsoft.DataTransfer.Runtime.SourceStageProcessor`1.ProcessInternal(NoData data)
       at Microsoft.DataTransfer.Runtime.PipelineProcessStageProcessor`2.Process(TInput data)
       at Microsoft.DataTransfer.Runtime.Provider.HybridRuntimeDataReader..ctor(HybridRuntimeCommand command, String commandBehavior, IMemoryLimit memoryLimit, Int32 previewCount)
       at Microsoft.DataTransfer.Runtime.Provider.HybridRuntimeCommand.ExecuteReaderInternal(String commandBehavior, Int32 rowCount)
       at Microsoft.DataTransfer.TransferTask.ExecuteQueryAsyncTask.QueryDataToInternalBlob()
       at Microsoft.DataTransfer.TransferTask.CopyTaskBase.Execute(),''Type=System.TimeoutException,Message=,Source=Microsoft.DataTransfer.DataContracts,StackTrace=   at Microsoft.DataTransfer.Common.Shared.HelperMethod.ExecuteWithTimeout(Action action, TimeSpan timeout, String timeoutErrorMessage)
       at Microsoft.DataTransfer.Common.Shared.HelperMethod.ExecuteWithTimeout(Action action, TimeSpan timeout, HybridDeliveryExceptionCode exceptionCode, String errorMessageFormat),'

    I did some googling and all results poin to the Azure Data factory copy issue. Any thoughts?

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    The time out is set to 300 seconds. Are you able to set this to a higher value yourself? Are you migration to BC SaaS, then it maybe a good idea to raise a support request via your CSP or partner.

    Thanks.

  • Community Member Profile Picture
    Community Member on at

    Hi,

    This is now resolved. For some reason this doesn't work in the Sandbox Environment. We were able to conduct the data migration in the Production Environment. As to why it doesn't work in the Sandbox Environment, we don't know yet. 

    Kind Regards,

    Francis

  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    That is good news to hear. It should work as well with Sandbox but here it does require a higher time out value I suppose. Raising a support request may help here if you want to get to the bottom of this.

    Thanks.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans