tencent cloud

TencentDB for SQL Server

문서TencentDB for SQL ServerOperation GuideData Migration (New)Using DTS to Migrate DataPre-Validation Failure HandlingSource Database Connectivity Check

Source Database Connectivity Check

PDF
포커스 모드
폰트 크기
마지막 업데이트 시간: 2025-09-18 18:19:36

Check Details

The Data Transfer Service (DTS) server needs to be able to connect to the source database; otherwise an error will be reported with the error details: "Check if the DTS server can connect to the source database."
The source server needs to be connected; otherwise, an error will be reported with the error details: "Insufficient migration account permissions. Unable to complete the migration."

Fixing Method

Serial Number
Error Details
Fixing Method
1
Check if the DTS server can connect to the source database.
Please check if the SQL service startup account for the source instance is using the built-in Local System account. You need to select "Built-in account" in "Log on as" in the startup configuration and modify it to start with the Local System account.
Please check if xp_cmdshell is enabled on the source instance. xp_cmdshell needs to be enabled. Please ensure the migration account has sysadmin permissions.
2
Insufficient migration account permissions. Unable to complete the migration.
이전 주제: Migration Network Check다음 주제: Target Database Connectivity Check

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백