Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
SQLServertoAzure migration : error while connecting to source in local computer
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 49%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DJP
1
Reputation point
I am trying to migrate my Database in SQL server on my local computer to Azure Database.
Under my Data Migration Service, when i create a "New Migration Project" and enter the details for the source SQL server(in my local computer), i get the following error. Image is also attached.
Can anyone help me to resolve this?
----------------------------------------------------------
"errorType":"Failed to connect, please check error details", "errorDetail":"Unhandled scenario exception. Scenario 'ConnectToSource.SqlServer', TaskId 'a54540c4-0201-4f24-b2fc-67680747c16e'.One or more errors occurred.Unable to get 'NetOnly' token for user.The validation information class requested was invalid." }
----------------------------------------------------------
Azure Database Migration service
{count} votes
-
CathyJi-MSFT 22,406 Reputation points Microsoft External Staff2021-04-27T02:57:54.17+00:00 Hi @DJP ,
Your issue is related to Azure Database Migration Service, I do not have the Azure environment to test this, so I add the tag azure-database-migration, people there will give you a better help.
I search this from google, on the Select source screen, we need to use a Fully Qualified Domain Name (FQDN) for the source SQL Server instance name. You can also use the IP Address for situations in which DNS name resolution isn't possible. Refer to MS document Tutorial: Migrate SQL Server to Azure SQL Database using DMS.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2021-04-28T13:58:00.52+00:00 @DJP Did you get a chance to look at above document. Please let us know if you need further help.
-
DJP 1 Reputation point
2021-04-28T15:06:34.303+00:00 Thank you for your response. I searched for the FQDN of the sql server.
Hope i have got it right, because now the connection seem to be taking a long time and the following error came. I set the server instance name as "(full computer name)(server name shown in connect to server popup in SSMS)"
So maybe i just need to "setup to allow remote connection".
Will post another question if it fails.
Sign in to comment
Sign in to answer