question

charliemelinguaringa-1751 avatar image
0 Votes"
charliemelinguaringa-1751 asked charliemelinguaringa-1751 commented

DMA connection error SQL Server

Hi, can you help me with this ?

I 'm using Data Assistan Migration and when trying to connect to a SQL Server 2000 to start an Assessment I get the following error:

Connection to the server failed.
Line 2: Incorrect syntax near 'max'.
Line 4: Incorrect syntax near 'max'.
Must declare the variable '@host_platform'.
Must declare the variable '@host_platform'.
Must declare the variable '@host_platform'.
Must declare the variable '@sqlSelectQuery'.


I have looked for information but I have not found anything, I already verified that the connection to the server works correctly

Thank you very much and best regards



sql-server-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered charliemelinguaringa-1751 commented

Hi @charliemelinguaringa-1751,

SQL server 2000 is not supported for Data Migration Assistant. Please check below screenshot.

85016-screenshot-2021-04-07-100425.jpg

Refer to the MS document Overview of Data Migration Assistant.

For SQL server 2000, suggest you using Upgrade advisor. You can download it from here.

In addition, SQL server 2000 is out of supported for a long time, don't let your infrastructure and applications go unprotected, please upgrade your SQL server to a newer version.


If the response is helpful, please click "Accept Answer" and upvote it, thank you.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you very much for your answer, it served me a lot

0 Votes 0 ·